MySQL: Difference between revisions
From DWIKI
m →FAQ |
mNo edit summary |
||
| Line 39: | Line 39: | ||
==FAQ== | ==FAQ== | ||
==speed up import from dump== | ===slow imports=== | ||
https://support.tigertech.net/mysql-large-inserts | |||
===speed up import from dump=== | |||
SET autocommit=0; | SET autocommit=0; | ||
SET unique_checks=0; | SET unique_checks=0; | ||
| Line 45: | Line 48: | ||
and after import | and after import | ||
COMMIT; | COMMIT; | ||
and turn them back on | |||
