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

3 votes205 views1 answer
Oracle revoke grant
SQL
0 vote193 views1 answer
Python mysql query where
SQL
0 vote201 views1 answer
Remove binlog mysql
SQL
0 vote258 views2 answers
How to check if a column exists in a SQL Server table?
SQL
1 vote193 views1 answer
How to get alternate records from a table in sql
SQL
-1 vote159 views3 answers
Ubuntu install mssql
SQL
2 votes209 views1 answer
Find all triggers in database
SQL
-1 vote176 views10 answers
Delete Query in SQL Server
SQL
-1 vote203 views1 answer
How to switch user in mysql
SQL
0 vote212 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL