"Tobyn Baugher" <[EMAIL PROTECTED]> wrote:
> 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.
Or create a .my.cnf file in the home directory of the user the cron job runs
as, chmod 600 .my.cnf and include the following in it:
Then you don't need to supply the -u and --password parameters to mysqldump.
Only that user can read .my.cnf and you won't need to supply those
parameters to the mysql commandline program or other MySQL programs if you
want to login as that default user.
President, Befriend Internet Services LLC
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php