Hi,
in any case you should use a script in advance as BackupPC can only
backup files.

Use a script to dump the database with mysqldump. Then back up with
BackupPC. Advantage: Database is available during backup and you can
backup only a single database (instead of all). Disadvantage: You need
some database admin skills to perform backup/ restore.

Or shut the database down, perform a backup with BackupPC and start the
database again. Advantage: Fast file restore. Disadvantage: MySQL is
down during backup.

Any further hints?

Greetings

Christian




Am 08.09.2014 um 16:09 schrieb Francisco Suarez:
> What would be a good approach for backing up MySQL databases on hosts
> with BackupPC?
>
>
> ------------------------------------------------------------------------------
> Want excitement?
> Manually upgrade your production database.
> When you want reliability, choose Perforce
> Perforce version control. Predictably reliable.
> http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> BackupPC-users mailing list
> BackupPC-users AT lists.sourceforge DOT net
> List:    https://lists.sourceforge.net/lists/listinfo/backuppc-users
> Wiki:    http://backuppc.wiki.sourceforge.net
> Project: http://backuppc.sourceforge.net/


------------------------------------------------------------------------------
Want excitement?
Manually upgrade your production database.
When you want reliability, choose Perforce
Perforce version control. Predictably reliable.
http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk
_______________________________________________
BackupPC-users mailing list
BackupPC-users AT lists.sourceforge DOT net
List:    https://lists.sourceforge.net/lists/listinfo/backuppc-users
Wiki:    http://backuppc.wiki.sourceforge.net
Project: http://backuppc.sourceforge.net/