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 > [email protected] > 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 [email protected] List: https://lists.sourceforge.net/lists/listinfo/backuppc-users Wiki: http://backuppc.wiki.sourceforge.net Project: http://backuppc.sourceforge.net/
