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 votes242 views2 answers
Tsql join multiple record in one string
SQL
0 vote236 views1 answer
Mariadb hours between two dates
SQL
0 vote233 views1 answer
T sql less than date
SQL
3 votes284 views1 answer
What is having
SQL
2 votes236 views2 answers
Compare date mysql
SQL
0 vote227 views1 answer
Mssql current date
SQL
0 vote229 views1 answer
Oracle current session details
SQL
0 vote252 views1 answer
Manage Database in MySQL
SQL
0 vote238 views1 answer
Postgresql show owner of database
SQL
0 vote245 views1 answer
How to print sql query
SQL