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 vote313 views1 answer
Mysql conf.d exampel
SQL
0 vote319 views1 answer
How to connect pgadmin with excel
SQL
6 votes338 views1 answer
Postgresql add enum value
SQL
6 votes328 views1 answer
Identify primary key in oracle table
SQL
4 votes324 views4 answers
Rollback in sql
SQL
0 vote312 views1 answer
Mysql change timestamp on update
SQL
0 vote330 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
6 votes302 views1 answer
Allsource oracle
SQL
0 vote345 views1 answer
Postgres foreign key multiple columns
SQL
1 vote349 views1 answer
Tsql replace value in json
SQL