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 vote144 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
0 vote140 views1 answer
For select oracle
SQL
2 votes103 views1 answer
Oracle cpu per session
SQL
0 vote127 views1 answer
Space not removing from column in sql
SQL
8 votes116 views1 answer
Mysql limit rows
SQL
3 votes106 views3 answers
Mysqldump: couldn
SQL
0 vote123 views1 answer
Unique element in sql
SQL
0 vote108 views1 answer
Test sql query
SQL
0 vote131 views1 answer
Mysql dump with table query
SQL
0 vote83 views1 answer
Get max salary from each department sql
SQL