how to duplicate a mysql table along with data using phymyadmin

Question

how to duplicate a mysql table along with data using phymyadmin

Answer 1

Construct a create table script, export it to .sql file, change the table name, and reimport it back.

Or better, take the original table schema, construct a create table script, and run the script in phpmyadmin, that should do.

Answer 2

To copy a table, you can just execute the following SQL:

CREATE TABLE copyname SELECT * FROM originalname

PHPMyAdmin also has built-in functionality to export table data to a flat file.