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 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 performance backup and restore > for large scale apps? > > Thanks > > -Ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]