Re: gmane

2012-08-14 Thread Daniel Brown
On Mon, Aug 13, 2012 at 8:25 PM, Thufir 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 really be nice if

Re: Recovery from a MySQL dump is too long !

2012-08-14 Thread Reindl Harald
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.

Recovery from a MySQL dump is too long !

2012-08-14 Thread 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 the slave and rsync the folder /var/lib/mysql to another