This guide 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 can 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 if 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
Each time the cron job runs, this will create a .sql and append the day, month and year to the end of the file.
To 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 into your account and checks 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. Confirm that these files exist and check the timestamp of when the backup was created once you are logged in to File Manager.
If we can help you in any way, please submit a ticket or join us in a Live Chat anytime. We are available 24/7/365, and we are dedicated to our client's success; every client truly matters to us.