On Mon, 2002-06-03 at 13:18, Kelly Meeks wrote: > Any way to use cron to automate the mysqldumping of databases on a nighly basis? > > Any examples would be greatly appreciated.
This line's gonna wrap, but it all goes on the same line :P 0 0 * * * /usr/local/bin/mysqldump -u <username> --password=<password> <database> > <outputfile> Obviously replace <username>, <password>, <database>, and <outputfile> with the values you want to use for each. Of course, I would never recommend putting a "secure" password in a text file like your crontab, so if you have admin rights on the server maybe consider setting up a read-only account with no password, or maybe a unique password that won't work on any other accounts. Never hurts to be a little paranoid. HTH, Toby -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
