MySQL: How to speed up restore operations from MySQL dump

by Massimo Caliman

~1 min read 01/01/2011

Categories

• MySQL

Tags

• code
• database
• en
• mysql

To speed up the operation of restoring a SQL dump in MySQL, you can proceed as follows:

set autocommit = 0;
set foreign_key_checks = 0;
source /root/mydump.sql
set foreign_key_checks = 1;
commit;
set autocommit = 1;