Bobcares

For every $500 you spend, we will provide you with a $500 credit on your account*

BLACK FRIDAY SPECIAL

*The maximum is $4000 in credits, Offer valid till December 6th, 2024, New Customers Only, Credit will be applied after purchase and expires after six (6) months

For every $500 you spend, we will provide you with a $500 credit on your account*

BLACK FRIDAY SPECIAL

*The maximum is $4000 in credits, Offer valid till December 6th, 2024, New Customers Only, Credit will be applied after purchase and expires after six (6) months

cPanel Backup Database by CronJob | How-to-guide

by | Dec 4, 2022

Here is a quick introduction to the cPanel backup database by cronjob from our experts. Our Server Management Support team is here to lend a hand with your queries and issues.

How to backup database in cPanel by Cronjob

Did you know that cPanel offers a cron job to run commands or scripts at specific times? This allows us to take backups at regular intervals. The database is responsible for storing the website’s critical information. Hence, taking a backup at regular intervals is extremely important. Let’s take a quick look at the steps to do this:

cPanel Backup Database by CronJob

  1. First, log in to cPanel.
  2. Then, head to the Advanced tab and select Cron Jobs.
  3. After that, enter your email in the Cron email section if you want to receive an email each time the cron runs a command. Alternatively, you can choose to redirect the command’s output to prevent individual emails for each cron job done.
  4. Next, we have to add a new cron job and the common settings. Our experts recommend opting for once per day.
  5. Then, enter the following command in the command box:

    mysqldump -uroot -ppassword --opt dbname > /home/mysql_backup/dbname-$( date +"\%Y_\%m_\%d" ).sql

    Where we make the following changes:

    • root: modify it to database user
    • password: modify it to database user password
    • dbname: modify it to database name
    • /home/mysql_backup/: modify it to the path where the backup file is to be added.
  6. Finally, we have to click the Add New Cron Job button. Now, cPanel cron will take a backup of the database every day.

Restoring the database from the backup is an easy job as well. All we have to do open Backup in cPanel in the Files section. Then, head to Restore a MySQL Database Backup, and navigate to the backup file on the local machine and click Upload.

Let us know in the comments if you run into trouble or need any assistance.

[Need assistance with a different issue? Our team is available 24/7.]

Conclusion

To wrap things up, our Support Engineers demonstrated how to backup a database in cPanel by Cronjob. We also got a look at how to restore the database from a backup file.

 

PREVENT YOUR SERVER FROM CRASHING!

Never again lose customers to poor server speed! Let us help you.

Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.

GET STARTED

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Never again lose customers to poor
server speed! Let us help you.