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 vote365 views1 answer
Mssql now diff 90 day
SQL
2 votes362 views1 answer
Change primary key sql
SQL
3 votes359 views1 answer
Oracle show trigger code
SQL
10 votes381 views4 answers
Primary key in sql
SQL
10 votes338 views3 answers
Sql limit results
SQL
0 vote377 views1 answer
Mysql get date diff in months
SQL
0 vote379 views1 answer
Oracle remove line breaks
SQL
2 votes354 views1 answer
Postgresql transaction
SQL
0 vote377 views1 answer
Excel export from sql using python
SQL
1 vote370 views1 answer
Rename table column name in mysql
SQL