Re: MySQL Backup
Robert Bridge <[email protected]> Sun, 15 Apr 2012 22:51:02 +0100
| Newsgroups | gmane.linux.gentoo.server |
|---|---|
| Message-ID | <CA+Uub+dcHe4GGiNrQA+z2gkV1FegWRSTHaRynGiYpqHNU8mAnw@mail.gmail.com> |
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 <[email protected]> wrote: > I run backuppc, calling MySQL dump as a pre-backup task... > ________________________________ > From: Tanner Danzey > Sent: 4/15/2012 10:56 AM > To: [email protected] > 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" <[email protected]> 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 >> >