Re: Re[2]: speedup mysql restore

2007-05-20 Thread Mogens Melander
On Sun, May 20, 2007 17:34, Vitaliy Okulov wrote: > Здравствуйте, Mogens. > >> --disable-keys, -K >> >> On Sun, May 20, 2007 16:28, Vitaliy Okulov wrote: >>> Здравствуйте, mysql. >>> >>> How i can speedup restore of mysql DB from file created by mysqldump? >>> > > Ok, but for innodb? > Well, you

Re[2]: speedup mysql restore

2007-05-20 Thread Vitaliy Okulov
Здравствуйте, Mogens. Вы писали 20 мая 2007 г., 18:47:33: > --disable-keys, -K > For each table, surround the INSERT statements with /*!4 ALTER TABLE > tbl_name DISABLE KEYS */; and /*!4 ALTER TABLE tbl_name ENABLE KEYS > */; statements. This makes loading the dump file faster because th