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

1 vote97 views2 answers
Oracle difference between two dates in seconds
SQL
0 vote97 views1 answer
Last date for each user sql
SQL
0 vote100 views1 answer
Recover deleted data from mysql database
SQL
4 votes94 views1 answer
Mysql set max connections
SQL
0 vote105 views1 answer
Utiliser sql ligne de commande
SQL
0 vote110 views1 answer
Psql attribute cannot login
SQL
0 vote117 views1 answer
Python connect to mysql in settings.py
SQL
0 vote137 views1 answer
Ms sql print more than 1 variable
SQL
0 vote116 views1 answer
No query unable to fetch row sqlite
SQL
23 votes67 views3 answers
Mysqldump
SQL