On Thu, Sep 11, 2003 at 04:27:10PM -0400, Brent Baisley wrote: > Have tried using the --opt parameter on mysqldump? This is supposed > optimize the dump speed and create a file optimized for reloading. I > haven't played with this option, so I don't know what kind of > difference it makes.
It makes a very big difference. --opt tells mysqldump to use MySQL's extended insert syntax, so you're insering the data for many rows with a single query. That can often give you a speed boost of 10x or more. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 4 days, processed 168,707,245 queries (449/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
