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

11 votes111 views2 answers
Turn off safe mode mysql
SQL
16 votes105 views2 answers
Mysql date between two dates
SQL
15 votes113 views4 answers
Pl sql
SQL
1 vote111 views1 answer
Mysql take number in string
SQL
4 votes115 views1 answer
Sql data types
SQL
2 votes100 views1 answer
Update with join sql server
SQL
2 votes104 views2 answers
Install sqlalchemy
SQL
3 votes134 views1 answer
Oracle function
SQL
0 vote166 views1 answer
Mysql update table from select on another table
SQL
1 vote99 views1 answer
Error code 1055
SQL