1#Innodb before import:
2SET FOREIGN_KEY_CHECKS = 0;
3SET UNIQUE_CHECKS = 0;
4SET AUTOCOMMIT = 0;
5#After import:
6SET UNIQUE_CHECKS = 1;
7SET FOREIGN_KEY_CHECKS = 1;
8COMMIT;
9
1#To disable MySQL indexes:
2ALTER TABLE `table_name` DISABLE KEYS;
3#To enable MySQL indexes:
4ALTER TABLE `table_name` ENABLE KEYS;