On Thursday 12 November 2009 15:10:39 Timothy Murphy wrote: > What is the best way to use BackupPC to backup a MySQL database?
A very easy way is install webmin. Login once to webmin and click MySQL server, and it will prompt you for an admin user's login and save it in a file only root can read. Click on the "backup databases" button and define your backup location, such as /var/backup/mysql. You can then run a backup of all MySQL databases with: /etc/webmin/mysql/backup.pl --all Webmin will offer to do that in a cronjob, and it is a good idea to do that nightly anyway. Then you can use dumppreusercmd to call it just before the backup. The advantage to this method is that it will dump all the databases. You don't have to write a custom mysqldump command for every database, and if you add a database later you don't have to edit the command. Regards, Tyler -- "A human being should be able to change a diaper, plan an invasion, butcher a hog, conn a ship, design a building, write a sonnet, balance accounts, build a wall, set a bone, comfort the dying, take orders, give orders, cooperate, act alone, solve equations, analyze a new problem, pitch manure, program a computer, cook a tasty meal, fight efficiently, die gallantly. Specialization is for insects." -- Lazarus Long, "Time Enough for Love", by Robert A. Heinlein ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ 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/
