mirnshi:speed_up_mysql_import
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
— | mirnshi:speed_up_mysql_import [2009/12/17 16:12] (current) – created mirnshi | ||
---|---|---|---|
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