- Log into cpanel - Select cron - Put the following in the first field 0 0 * * * - In the second box place: mysqldump --opt --user=database_user --password=database_pass database_name > /home/username/foldername/backup.sql Please note you will have to replace the values with your real information. This will backup your database every night at 12pm.