Back to Troubleshooting

How To Restore An SQL Database In cPanel

The SQL Database holds important information for accessing, retrieving, and editing your website. You can download a copy of your database to save as a backup if your data needs to be restored. This article was created to demonstrate how to create and download a database file to use it to restore the MySQL Database. makes and stores regular backups of your website on our servers. We recommend that you also keep a backup for your records as best practice. If you need to restore your website from the past seven days, please fill out a support ticket and include the date from the past seven days and any specific website, database, or other content you would like to have restored.

Step 1: Create A MySQL Backup In cPanel

    1. Within cPanel, navigate to the Backup Wizard tool by clicking on the “Backup Wizard” icon. You will use this to create your backups.

    2. Click on the “MySQL Databases” button under the “Select Partial Backup” section.

Step 2: Download The MySQL Backup File

Note: The file will automatically save in your Downloads folder. You will need to move it to a more permanent location using the file explorer. Make sure that you take note of where you have saved this file, and the name and date, as you will need to refer to it later.

Step 3: Restore The MySQL Database

  1. Return to the Backup Wizard in cPanel.
  2. Click the “Restore” button.

  3. Select “MySQL Databases”.

  4. Click “Choose File”.

  5. Select the backup file that you have previously downloaded to your computer.

  6. Click “Upload” to complete your task

If you need further help restoring your website, please contact Westhost support by opening a chat or creating a ticket within your WestHost CHI dashboard.

Related Articles

How To Know If My Server Is Down
Account Suspension Help
How To Fix A Broken Website
How To Resolve The HTTP Error 403 Forbidden
My Site Is Down - What Do I Do

Can’t Find what you need?

No worries, Our experts are here to help.