[Box Backup] Backup Ninja

[Jamie Neil]

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 | <jamie@versado.net> | 0870 7777 454
Versado I.T. Services Ltd. | http://versado.net/ | 0845 450 1254