Crontab

Hi,

I'm trying to run a shell script through the cron which does:

mysqldump --user=root -p --all-databases > all_databases.sql

however, this command requires a password, how do I pass the password to mysql?

Thanks!

Either use a .my.cnf file where you store the password for the user that runs the crontab, or run mysqldump --user=<usr> --password=<password>... Note that this will appear in logs though...

//NoXcuz