Здравствуйте, Mogens. Вы писали 20 мая 2007 г., 18:47:33:
> --disable-keys, -K > For each table, surround the INSERT statements with /*!40000 ALTER TABLE > tbl_name DISABLE KEYS */; and /*!40000 ALTER TABLE tbl_name ENABLE KEYS > */; statements. This makes loading the dump file faster because the > indexes are created after all rows are inserted. This option is effective > only for non-unique indexes of MyISAM tables. > On Sun, May 20, 2007 16:28, Vitaliy Okulov wrote: >> Здравствуйте, mysql. >> >> How i can speedup restore of mysql DB from file created by mysqldump? >> >> -- >> С уважением, >> Vitaliy mailto:[EMAIL PROTECTED] >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >> >> >> -- >> This message has been scanned for viruses and >> dangerous content by OpenProtect(http://www.openprotect.com), and is >> believed to be clean. >> >> > -- > Later > Mogens Melander > +45 40 85 71 38 > +66 870 133 224 Ok, but for innodb? -- С уважением, Vitaliy mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
