Table Backup in MySQL

Here's what I believe is the most efficient way to backup a table:

Through Navicat, open a console window on the server/database you are backing up to.

Then do this:

mysql>; create table backup.errorCdrs_20140309 like clover.errorCdrs;

Query OK, 0 rows affected

mysql> insert into backup.errorCdrs_20140309 select * from clover.errorCdrs;

Query OK, 5260808 rows affected

Records: 5260808  Duplicates: 0  Warnings: 0

I don't have a timing to support my claim that this is the most efficient, but I think it is because it is done at the server, so the traffic should be within the server. You could just go to the file system and make a copy the table files and maybe that would be more efficient, but I think it is better to work within the MySQL system.

What is the Trivium?

In medieval universities, the trivium comprised the three subjects that were taught first: grammar, logic and rhetoric. The word is a Latin term meaning "the three ways" or "the three roads" forming the foundation of a medieval liberal arts education. This study was preparatory for the quadrivium, which consists of geometry, arithmetic, astronomy, and music. Combining the trivium and quadrivium results in the seven liberal arts of classical study.

Source: http://en.wikipedia.org/wiki/Trivium

Definition of a Human Being

A human being should be able to change a diaper, plan an inva­sion, butcher a hog, conn a ship, design a building, write a sonnet, balance accounts, build a wall, set a bone, comfort the dying, take orders, give orders, cooperate, act alone, solve equations, analyze a new problem, pitch manure, program a computer, cook a tasty meal, fight efficiently, die gallantly. Specialization is for insects.
 – Lazarus Long, Time Enough For Love