On Fri, Sep 25, 2015 at 09:01:29AM -0700, Stephen Thompson wrote: > > > > I run daily backups of my database and had finished my monthly full run > for September, so I was technically covered. However I was not looking > forward to restoring a 900+Gb mysql database from a text dump which on > my system would take days, if not an entire week. The last time I had > to restore database from backup it was 4 or so years ago and my database > was only 300-400Gb back then. > > Stephen > >
One word: innobackupex. You'll be up running in a few minutes again as opposed to a week when using a text file created by mysqldump (which, much like MyISAM tables, should be taken round the back and taken out of its misery once and for all ;)) All the best, Uwe ------------------------------------------------------------------------------ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
