Database Backups using a cron job

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

 

  1. Login into cPanel 
  2. Navigate to the Advanced section and click on Cron Jobs

    cPanel Cron Jobs
     

  3. Enter the email address for notifications 
  4. Select a common setting from the drop down menu, such as once per week
  5. Select a non peak hour to run the cron job
  6. Enter in the following into the command area:
    Replace the following three items

    1. <cPanelUserName> with your cPanel username
    2. <FILE_NAME_HOME_DIRECTORY_> with the name of the backup
    3. <cPanelPassword> with your cPanel account password

     

     

  7. 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 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.

 

If we can help you in any way, please submit a ticket, give us a phone call 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.


Share:

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.