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

2 votes227 views1 answer
Remove foreign key constraints in postgres
SQL
-2 votes167 views1 answer
Modify column name in tsql
SQL
7 votes169 views3 answers
Postgre describe table
SQL
0 vote158 views1 answer
Postgresql conectar
SQL
0 vote167 views1 answer
Update sqlite
SQL
-1 vote183 views1 answer
Search all database tables for a value sqlserver
SQL
5 votes228 views2 answers
How to ascending order in sql
SQL
0 vote161 views1 answer
Python mysql query where
SQL
0 vote129 views1 answer
Import sql file in mysql linux
SQL
18 votes174 views4 answers
Uninstall mysql ubuntu 18.04
SQL