[Box Backup] Backup Ninja
Tue, 31 Oct 2006 18:51:01 +0000
Per Thomsen wrote:
> On 10/31/06 8:05 AM, Richard Hurt wrote:
>> I was just thinking about how to back up a live MySQL database using
>> Box Backup. The only difference is that I would like to back up the
>> database live using lazy mode, not dump it once a day. Any
>> clues/hints from anyone?
> If you want to back up a live mySQL database, there are a couple of
> options (with caveats):
> * You can't count on the datafiles being consistent during backup,
> so if you snapshot your database every hour or so (mysqlhotcopy
> does a good job for me), you can have bbackupd pick these files up
> whenever it runs. This is what I do (although I only run
> mysqlhotcopy once a day), and it works well for me.
Backup Ninja provides a script called ninjahelper that supports both
mysqldump and mysqlhotcopy as a backup method. It also handles Postgres,
OpenLDAP, and subversion repositories.
Jamie Neil | <firstname.lastname@example.org> | 0870 7777 454
Versado I.T. Services Ltd. | http://versado.net/ | 0845 450 1254