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.



PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to