Backup

How to Backup & Restore MySQL Database in cPanel

To backup the databases please do the following:

  1. Login to your control panel and click Backups.
  2. Under Download a MySQL Database Backup, click the name of the database.
  3. Click Save As.
  4. Select a destination for where you would like the back up to be saved, locally.

Once you have a backup, if you ever inadvertently lose your data, then you can restore the database easily and quickly.

To restore a database, please do the following:

  1. Login to your control panel and click Backups.
  2. Click the Browse button next to the option which says Restore a MySQL Database.
  3. Select the .sql.gz file which you want restored.
  4. Click the Open button and click the Upload button.

Your database driven website should be working again.

Backup System Configuration Files Using WHM backup Feature

  1. Login to the WHM
  2. On the main screen, click on the Backup >> Configure Backup
  3. On the Configure Backup page “Enabled” the Backup Configuration Files option.

Now you know how to backup the system configuration files of your dedicated hosting server via WHM Backup Feature.

How to Backup and Restore cPanel Accounts via SSH

How to create backup of Individual cPanel Account via SSH?

1: Log-in to the SSH as Root user.

2: Enter the following command string on the command line interface:

/scripts/pkgacct username

[Note: The account backup will be created in the current directory you are in.]

How to Restore the Individual cPanel Account via SSH?

Step 1: To restore the cPanel account backups, enter the following command

/scripts/restorepkg username

[Note: In order to restore the data, you need to be in the directory where the backup file is stored.]