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
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/