We use xtrabackup from percona, with tar to generate backup of the running mysql servers in a fraction of the time it would take to use mysqldump. Restoration is than just a case of copy the uncompressed tarball into place and starting mysql.
It's a pain when it comes to restoring individual tables, but for a full system backup it's fast and easy. RobbieAB. On 15 April 2012 20:40, Jesse Pasichnyk <je...@pasichnyk.net> wrote: > I run backuppc, calling MySQL dump as a pre-backup task... > ________________________________ > From: Tanner Danzey > Sent: 4/15/2012 10:56 AM > To: gentoo-server@lists.gentoo.org > Subject: Re: [gentoo-server] MySQL Backup > > > I usr MySQL's "mysqldump" and a daily cron task that zips it up and sends it > to my NFS backup drive in dated folders. It works just fine for my minute > data set. > > On Apr 15, 2012 1:04 PM, "Gerry Smith" <smith.ge...@gmail.com> wrote: >> >> What's recommended for MySQL backups these days ? >> I've been using zmanda, which I found very easy to install and use, >> but it doesn't seem to be in portage anymore ? >> >> Thanks, >> >> Gerry Smith >> >
