Mysql cronjob backups

[clangoon]

Does anyone know how I would schedule a cron job to backup a phpBB2 forum at midnight each night?
I've looked on the web but not found much helpful stuff

 

[Slothie]

Easiest thing in the world.

Add this to your crontab

0 0 * * * * mysqldump -udbusername -pdbpassword db_name | gzip > /home/cpanelusername/yourfolder/mysql_backup.gz

 

[clangoon]

Could that be changed to save the file+date, so it didn't overwrite the backup from the day before?

 

[Corey]

I think you'd have to use cron to execute a PHP script or something similar. I don't believe you can insert variables into the cron command like day\time.

-Corey