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

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. Stop