03 September 2010
Copying a table in MySQL
CREATE TABLE new_table LIKE production.table;
INSERT new_table SELECT * FROM production.table;
If you need a MySQL backup solution, take a look at zmanda
a thread in the fabric