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

65 votes551 views6 answers
Sql add column to table
SQL
0 vote339 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
2 votes311 views1 answer
Sqlite show table indexes
SQL
6 votes349 views2 answers
Mysql 1 day ago
SQL
0 vote351 views1 answer
Postgres get database encoding
SQL
0 vote339 views1 answer
Changing name of column and datatype in sql
SQL
14 votes313 views2 answers
How to auto increment in sql
SQL
3 votes459 views1 answer
How to get yesterday date in sql
SQL
0 vote351 views1 answer
Create a sql server database programmatically
SQL
0 vote378 views1 answer
Copy row from db to db mysql
SQL