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 vote188 views2 answers
Oracle leftmost characters
SQL
0 vote163 views1 answer
Install mysql 8 linux
SQL
3 votes161 views1 answer
Oracle rollback
SQL
1 vote177 views2 answers
Get table column names sql laravel
SQL
0 vote174 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
0 vote164 views1 answer
Authentication in sql server
SQL
0 vote159 views1 answer
Mysql select last 15 minutes
SQL
0 vote247 views1 answer
Shortcut run sql pgadmin
SQL
0 vote176 views1 answer
Mysql local password denied
SQL
1 vote216 views1 answer
Select last row from SQL Table
SQL