using mysqldump in a cronjob options in the user panel

[sandoz]

i would like to automate the backup of a large forum with the cron job options from the cpanel advanced options with something like this:
0 0 * * * /usr/bin/mysqldump --opt dbname -u dbuser -ppass > /home/username/dbname.sql

will that work from within the user panel?

 

[cPanelTristan]

It would be better to do this in root crontab without using the password and running it as -u root without the -p flag. The root user can run such a cron without being required to enter the password. I'm not certain that it is a good idea to pass the password via a cron.

To add a cron in root crontab, you can either use "crontab -e" command or directly edit /var/spool/cron/root file in root SSH.