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

8 votes305 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote308 views1 answer
Compare field sql server
SQL
0 vote273 views1 answer
Mysql_num_fields in mysqli
SQL
52 votes501 views6 answers
Rename column sql
SQL
0 vote297 views1 answer
How to list function in psql
SQL
0 vote266 views2 answers
Sql query unique
SQL
3 votes289 views2 answers
Find the median in sql
SQL
0 vote321 views1 answer
Pl sql disable trigger
SQL
0 vote300 views2 answers
Mysql on update current_timestamp
SQL
0 vote313 views2 answers
Compound operator in sql
SQL