How can I easily copy a table?
You can use CREATE TABLE dest AS SELECT * FROM source
. See CREATE TABLE.
Or, create a new empty table using the schema of the original table from SHOW CREATE TABLE source
and copy data from source table into the new table using INSERT INTO dest SELECT * FROM source
.