MySQL Forums
Forum List  »  Data Recovery

Re: Recovery from a MySQL dump is too long !
Posted by: Scott Nemes
Date: August 15, 2012 03:15PM

I'd look into using Percona's XtraBackup (http://www.percona.com/doc/percona-xtrabackup/).

With that, you can do a hot backup (if all of your tables are InnoDB), which should restore much quicker than a mysqldump backup would.

The XtraBackup manual has a few easy to follow guides for common backup and restore scenarios, which should cover what you are looking to do.

--
Scott Nemes
MySQL DBA

http://www.linkedin.com/in/scottnemes
http://www.twitter.com/ScottNemes

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Recovery from a MySQL dump is too long !
1748
August 15, 2012 03:15PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.