Haim Evgi
Reputation: 125604
Copy a MySQL table including indexes
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?
Upvotes: 66
Views: 34614
Answers (0)
Related Questions
- Copy table without copying data
- Duplicating a MySQL table, indices, and data
- Copy a table (including indexes) in postgres
- How to copy indexes from one identical table to another existing identical table
- How to duplicate a table with keys & other structure features retained in MySQL?
- How can I copy table db to db in MySqL
- MySQL Copying tables
- how to create index table based on an existing table in Mysql
- mysql copy table?
- Copy MySQL table using backup