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 vote276 views1 answer
How do you use sql in you company
SQL
-1 vote273 views1 answer
What is in operator
SQL
0 vote257 views1 answer
Sql comparison operators
SQL
2 votes302 views2 answers
Mysql on duplicate key update get value from values
SQL
0 vote274 views1 answer
Oracle list subpartitions
SQL
5 votes271 views1 answer
Ignore duplicate rows in sqlite
SQL
0 vote303 views1 answer
SQLServerException.makeFromDatabaseError
SQL
1 vote278 views1 answer
Rermove categories woocommerce sql
SQL
1 vote270 views3 answers
Postgresql crete view
SQL
0 vote261 views1 answer
Mysql begin statement
SQL