--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.
