List:General Discussion« Previous MessageNext Message »
From:Mogens Melander Date:May 20 2007 2:47pm
Subject:Re: speedup mysql restore
View as plain text  
--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:vitaliy.okulov@stripped
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>
> --
> 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



-- 
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.

Thread
speedup mysql restoreVitaliy Okulov20 May
  • Re: speedup mysql restoreMogens Melander20 May
    • Re[2]: speedup mysql restoreVitaliy Okulov20 May
      • Re: speedup mysql restoreBaron Schwartz20 May
      • Re: Re[2]: speedup mysql restoreMogens Melander20 May
  • Re: speedup mysql restoremos21 May
Re: speedup mysql restoreRay Cauchi21 May
Re: speedup mysql restoreEric Bergen21 May