From: Dan Rogart (dan.rogartrevolutionhealth.com)
Date: Fri Feb 15 2008 - 13:10:09 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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, "dvdnewfoundmarket.com" <dvdnewfoundmarket.com> 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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]