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

3 votes176 views1 answer
Postgres kill running query
SQL
9 votes172 views1 answer
Sql server get utc date
SQL
0 vote151 views1 answer
Postgresql add leading zeros
SQL
2 votes186 views2 answers
Mysql limit
SQL
1 vote174 views1 answer
Postgresql reset serial counter after deleting content
SQL
2 votes171 views2 answers
Spring import sql
SQL
0 vote209 views1 answer
Oracle date summer time
SQL
1 vote170 views1 answer
Substr sql last character
SQL
8 votes197 views2 answers
Grant all privileges database postgres to user
SQL
2 votes176 views1 answer
How to select first row of database sql
SQL