User Tools

Site Tools


mirnshi:speed_up_mysql_import

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

mirnshi:speed_up_mysql_import [2009/12/17 16:12] (current)
mirnshi created
Line 1: Line 1:
 +====== speed up  mysql import ======
 +
 +Generally, it is very slow to restore the data from mysqldump file. Here is a tip to speed up this work:
 +//
 +//
 +    % mysql -u someuser -p
 +    > SET AUTOCOMMIT=0;​
 +    > SET UNIQUE_CHECKS=0;​
 +    > SET FOREIGN_KEY_CHECKS=0;​
 +    > source dump.sql;
 +    > SET FOREIGN_KEY_CHECKS=1;​
 +    > UNIQUE_CHECKS=1;​
 +    > COMMIT;
 +
 +
 +{{tag>}}
 +
 +~~LINKBACK~~
 +~~DISCUSSION~~
  
mirnshi/speed_up_mysql_import.txt ยท Last modified: 2009/12/17 16:12 by mirnshi