List:General Discussion« Previous MessageNext Message »
From:Vitaliy Okulov Date:May 20 2007 3:34pm
Subject:Re[2]: speedup mysql restore
View as plain text  
Здравствуйте, 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: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




Ok, but for innodb?

-- 
С уважением,
 Vitaliy                          mailto:vitaliy.okulov@stripped

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