This article is about creating a cron job in cPanel to make a backup of your databases. This article is intended for Hostwinds clients who use cPanel and have access to create a cron job through the cPanel interface. Hostwinds clients are encouraged to keep a working backup before performing any upgrades, site maintenance or before making changes in case the database needs to be restored.
How To Set Up a Cron Job to Backup Your Database
- Login into cPanel
- Navigate to the Advanced section and click on Cron Jobs
- Enter the email address for notifications
- Select a common setting from the drop down menu, such as once per week
- Select a non peak hour to run the cron job
- Enter in the following into the command area:
Replace the following three items
- <cPanelUserName> with your cPanel username
- <FILE_NAME_HOME_DIRECTORY_> with the name of the backup
- <cPanelPassword> with your cPanel account password
1mysqldump --opt -Q -u <cPanelUserName> -p<cPanelPassword> --all-databases > /home/<cPanelUserName>/<FILE_NAME_HOME_DIRECTORY_>`date +%d%m%y`.sql
- Each time the cron job runs, this will create a .sql and append the day, month and year to the end of the fileTo ensure your account does not build backups of your databases and increase your account’s disk space usage, it is important to download copies of these backups to your computer and remove them from your server
Confirm Your Backups
It’s a good idea to login to your account and check that these files are being created. That way, if you need to restore your database from a backup, you can download the file and restore your database from a backup. If you use cPanel, you can do this by logging into File Manager. Simply confirm that these files exist and check the timestamp of when the backup was created once you are logged into File Manager.