Copy an existing MySQL table to a new table

From here:

To make a copy of the table recipes which is in a different database called production into a new table called recipes_new in the currently selected database, use these two commands:

CREATE TABLE recipes_new LIKE production.recipes;
INSERT recipes_new SELECT * FROM production.recipes;


The first command creates the new table recipes_new by duplicating the structure of the existing table. The second command copies the data from old to new.