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 vote258 views1 answer
Reset postgresql password windows
SQL
0 vote283 views1 answer
Min:sec datediff mssql
SQL
0 vote265 views1 answer
Oracle sql count occurrences of value in column
SQL
7 votes268 views5 answers
Sql remove spaces
SQL
0 vote278 views1 answer
Get statis values sql
SQL
14 votes268 views1 answer
Sql value of string
SQL
0 vote299 views1 answer
CONVERT time string into 12 hours in sql
SQL
0 vote255 views1 answer
Postgresql heritage
SQL
0 vote366 views5 answers
Right join
SQL
-1 vote239 views2 answers
How to display top 50 rows?
SQL