This shows you the differences between two versions of the page.
| — |
mirnshi:speed_up_mysql_import [2009/12/18 00: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~~ | ||
