Mysql: duplicating a table

You need to do :

CREATE TABLE newtable LIKE oldtable;
INSERT newtable SELECT * FROM oldtable;

This creates copy of existing Mysql table with indexes