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

5 votes311 views2 answers
Sql number columns
SQL
0 vote286 views2 answers
Sql regex vowel
SQL
1 vote279 views1 answer
Input in mysql
SQL
8 votes286 views1 answer
Oracle add month
SQL
3 votes319 views2 answers
Mysql update row
SQL
0 vote300 views1 answer
Set classpath for mysql-connector.jar
SQL
0 vote293 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
1 vote315 views1 answer
Myql find duplicates
SQL
2 votes277 views2 answers
Oracle multiple insert
SQL
0 vote291 views1 answer
Syntax for changing column size in mysql
SQL