A lot of sites will tell you to do this:
CREATE TABLE t2 SELECT * FROM t1;
Problem is that you’ll lost your auto_increment, primary key and any other indexes you have (and any other extra meta data like that.)
This might not be the best solution, but hey it worked for me:
CREATE TABLE t2 LIKE t1;
INSERT INTO t2 SELECT * FROM t1;
Hope that helps somebody.. I only noticed I’d lost all my primary keys after copying a load of tables using the old method.