#Innodb before import: SET FOREIGN_KEY_CHECKS = 0; SET UNIQUE_CHECKS = 0; SET AUTOCOMMIT = 0; #After import: SET UNIQUE_CHECKS = 1; SET FOREIGN_KEY_CHECKS = 1; COMMIT;
#To disable MySQL indexes: ALTER TABLE `table_name` DISABLE KEYS; #To enable MySQL indexes: ALTER TABLE `table_name` ENABLE KEYS;