[TriLUG] back up your $HOME
igor at igorpartola.com
Fri May 27 10:04:55 EDT 2011
I stop the MySQL instance before I take the backup. I am aware that
just copying data from under a running mysqld would break things
pretty horribly with InnoDB data files. In my case it is fine to stop
mysqld since I run it in a master-slave configuration and I take the
backups off the slave. This is not the most elegant setup but it was
quick and dead simple.
On Fri, May 27, 2011 at 9:57 AM, Michael Peters <mpeters at plusthree.com> wrote:
> On 05/27/2011 09:43 AM, Igor Partola wrote:
>> I have never used rsnapshot, but it sounds a lot like rdiff-backup.
>> rdiff-backup is fantastic for backing up MySQL data files, since it
>> can store binary deltas of large files. It's like magic.
> Just to poke my head in here, I really hope you're not just making copies of
> the mysql data files as a backup. That will break in all kinds of unfun
> For mysql backups you really need a tool like xtrabackup
> Michael Peters
> Plus Three, LP
More information about the TriLUG