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 vote336 views1 answer
Adding generated time in row mysql workbench
SQL
1 vote334 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
15 votes317 views6 answers
Psql
SQL
0 vote351 views1 answer
Postgres meta command to show all rows in table
SQL
0 vote337 views1 answer
Flexible search query delete table
SQL
1 vote301 views1 answer
Find logged in users mysql
SQL
0 vote355 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote316 views1 answer
Sql insert tuple
SQL
12 votes328 views2 answers
Delete all entries postgres
SQL
1 vote375 views1 answer
Postgresql float 2 decimal places
SQL