I use a cron job that backups my databases on a daily/weekly basis and then depend on backuppc to grab those static files - the backup of mysql is not dependant on the DumpPreUserCmd in backuppc. The command I have cron'd is:
mysqldump --opt --all-databases -u root | gzip -9 > /backups/mySQL-AllDB.sql.gz On Mon, Jul 6, 2009 at 13:44, Philip Tait <[email protected]> wrote: > I have done some searching, and have not been able to find a complete > working example for properly backing up a MySQL database with BackupPC. > > If someone would be willing to share their working DumpPreUserCmd and > DumpPostUserCmd setup for creating MySQL database dumps for backup, thus > saving me some debug cycles, I'll add this to the Wiki page, since this > question comes up periodically. > > Thanks, > > Philip J. Tait > http://subarutelescope.org > > > > ------------------------------------------------------------------------------ > _______________________________________________ > BackupPC-users mailing list > [email protected] > List: https://lists.sourceforge.net/lists/listinfo/backuppc-users > Wiki: http://backuppc.wiki.sourceforge.net > Project: http://backuppc.sourceforge.net/ >
------------------------------------------------------------------------------
_______________________________________________ BackupPC-users mailing list [email protected] List: https://lists.sourceforge.net/lists/listinfo/backuppc-users Wiki: http://backuppc.wiki.sourceforge.net Project: http://backuppc.sourceforge.net/
