From: Emre Hasegeli Date: September 2 2012 11:39am Subject: Re: Recovery from a MySQL dump is too long ! List-Archive: http://lists.mysql.com/backup/155 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit On Sat, 1 Sep 2012 21:15:15 +0200, Manuel Arostegui wrote: > Hello *, > > My INNODB database has a size of 80GO. I've a replication setup on 3 > slaves and I backup my db from them. > If a problem occurs on the database, a recovery from a dump takes > around 6H ! That's too long for us. > > 2 ideas : > 1. Stop the slave and rsync the folder /var/lib/mysql to another > server > 2. Stop the slave, take a dump and when it's finish, pull the dump in > another MySQL instance daily. > > Do you have another ideas ? What's your advices ? I dump and restore the tables in parallel. My simple scripts are on the GitHub [1]. [1] http://github.com/tart/SimpleMySQLParallelDumpRestore