From: Mogens Melander
Date: May 20 2007 2:47pm
Subject: Re: speedup mysql restore
List-Archive: http://lists.mysql.com/mysql/206863
Message-Id: <4877.90.184.17.152.1179672453.squirrel@mail.fumlersoft.dk>
MIME-Version: 1.0
Content-Type: text/plain;charset=utf-8
Content-Transfer-Encoding: 8bit

--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=mogens@stripped
>
>
> --
> 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.