CREATE TABLE copy LIKE original; ALTER TABLE copy DISABLE KEYS; SET unique_checks=0; SET foreign_key_checks=0; INSERT INTO copy SELECT * FROM original; ALTER TABLE copy ENABLE KEYS; SET unique_checks=1; SET foreign_key_checks=1;