[TriLUG] back up your $HOME

[Igor Partola]

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.

Igor

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
> ways.
>
> For mysql backups you really need a tool like xtrabackup
> (http://www.percona.com/docs/wiki/percona-xtrabackup:start)
>
> --
> Michael Peters
> Plus Three, LP
>