Faster mysql imports

#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;

Source: support.tigertech.net

Faster mysql imports

#To disable MySQL indexes:
ALTER TABLE `table_name` DISABLE KEYS;
#To enable MySQL indexes:
ALTER TABLE `table_name` ENABLE KEYS;

Source: support.tigertech.net

Similar codes

0 vote127 views1 answer
Drop view in mysql
SQL
4 votes104 views2 answers
Sql vs mysql
SQL
0 vote85 views1 answer
Big query add table rows to another table
SQL
0 vote114 views1 answer
How to insert same table data using mysql query
SQL
0 vote126 views1 answer
Sqlite unique multiple columns
SQL
0 vote116 views2 answers
Drop check constraint in ms sql
SQL
0 vote122 views1 answer
Value of sold product using having and group by in sql
SQL
0 vote117 views1 answer
Postgres populate table from another table
SQL
0 vote127 views1 answer
How to update sql server version
SQL
0 vote113 views1 answer
Fast sql column count
SQL