very slow restore

2008-02-15 Thread dvd
Hi: I am restoring a 10 million row table using a dump file created via mysqldump.  On a very fast server, It  finishes in 8 hours. Is it  something normal ?  I know the alternative to copy file directly but here is not an option . So can I say mysql does not have its own way for high

Re: very slow restore

2008-02-15 Thread Dan Rogart
You might want to check out Baron Schwartz's maatkit: http://maatkit.sourceforge.net/ It has scripts which let you take dumps and do restores using multiple threads. It might help speed things up for you. -Dan On 2/15/08 1:55 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi: I am