Recovery from a MySQL dump is too long !

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

Re: Recovery from a MySQL dump is too long !

Am 14.08.2012 09:42, schrieb Bob Sauvage: 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

Re: gmane

On Mon, Aug 13, 2012 at 8:25 PM, Thufir hawat.thu...@gmail.com wrote: Looking at: Group gmane.comp.db.mysql.general Description The main list for general MySQL discussion Address mysql@... Status posting allowed http://dir.gmane.org/gmane.comp.db.mysql.general It would