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

0 vote301 views1 answer
Partitioning in oracle-base
SQL
4 votes320 views2 answers
Truncate oracle
SQL
17 votes309 views6 answers
Current date in sql
SQL
2 votes306 views2 answers
Mysql limit
SQL
1 vote298 views1 answer
Change table to innodb mysql
SQL
0 vote293 views1 answer
1 column values in to 1 single row in sql
SQL
0 vote316 views1 answer
Sql delete from with relation
SQL
4 votes316 views4 answers
Rollback in sql
SQL
12 votes324 views4 answers
Psql command not found
SQL
0 vote299 views1 answer
Sqlite update only if greater
SQL