The Network Administrator

This will backup all of your mysql databases nightly at midnight

Open a command prompt and type crontab -e

type 0 0 * * * /usr/bin/mysqldump -u username -p userpassword --all-databases > /usr/share/bugzilla/mysql/backups/dbbackup.sql

make any changes that you need and then type wq! to save and quit out of the script.