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 vote209 views1 answer
Name of today sql
SQL
1 vote212 views1 answer
Mysql take number in string
SQL
0 vote243 views1 answer
Sqlalchemy orm duplicate
SQL
1 vote200 views1 answer
Crontab every month
SQL
2 votes200 views1 answer
Sql ignore accents
SQL
79 votes589 views6 answers
Grepper code
SQL
12 votes196 views3 answers
Duplicate a column in sql
SQL
25 votes245 views4 answers
Metadata
SQL
0 vote229 views2 answers
Athena drop partition
SQL
6 votes227 views2 answers
Mysql timestamp to date
SQL