MySQL: How to speed up restore operations from mysql dump

by Massimo Caliman

~1 min read 01/01/2011

Categories

• 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;