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 vote137 views1 answer
Oracle service name view
SQL
1 vote136 views1 answer
Window function mysql
SQL
6 votes93 views2 answers
Spring data jpa application.properties mysql
SQL
-1 vote132 views1 answer
Pl/sql how to delete a trigger
SQL
-1 vote141 views3 answers
Update mongodb version ubuntu
SQL
0 vote140 views1 answer
Oracle array
SQL
0 vote139 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
0 vote167 views2 answers
Suse Linux restart MySQL
SQL
3 votes149 views1 answer
Oracle cannot access v$session
SQL
0 vote167 views2 answers
Postgres isnull
SQL