Copy a MySQL table including indexes

Question

I can copy a MySQL table to create a new table:

CREATE TABLE newtable SELECT * FROM oldtable

This works, but the indexes are not copied to the new table. How can I copy a table including the indexes?

indexes not create vs prevent the indexes is ambiguous, what do you want to do? — Pentium10
possible duplicate of Duplicating a MySQL table, indexes and data — luchaninov
@luchaninov the answer on that question mentions this question. This is an infinite loop. — FrancescoMM

raveren raveren · Accepted Answer · 2010-03-10T09:53:37

122

votes

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