Re: Recovery from a MySQL dump is too long !
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
Subject
Views
Written By
Posted
3225
August 14, 2012 01:20AM
Re: Recovery from a MySQL dump is too long !
1770
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.