How To Restore An SQL Database In cPanel

How To Restore An SQL Database In cPanel


Skip to end of metadata
Go to start of metadata

The SQL Database holds information for accessing, retrieving and editing your website. You can download a copy of the database to keep as a backup in the event that your data needs to be restored to a previously saved version. This article acts as a guide for creating and downloading a database file to restore the MySQL Database.

UK2.NET makes and stores regular backups of your website on our servers. We recommend that you keep an additional copy of your website for your own records. 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 by clicking on the “Backup Wizard” icon. The Backup Wizard tool will be used to create and restore your backup database.

    backup wizard

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

    select backup

Step 2: Download The MySQL Backup File

 

download sql database

The file created from your database will automatically save to your Downloads folder. You will need to move it to a more permanent location using the file explorer. Make sure that you take a note of the name and date of your file, and where you saved it, as you will need to refer to it to complete this process.

Step 3: Restore The MySQL Database

  1. Return to the Backup Wizard in cPanel.
  2. Click on the “Restore” button.
    restore
  3. Select “MySQL Databases”.
  4. Click “Choose File”.
  5. Select the backup file that you previously downloaded and saved to your local computer.
  6. Click “Upload”.

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





    • Related Articles

    • How To Backup Your Database Using PHPMyAdmin

      PHPMyAdmin is a tool used to manage your database. You can use it to backup your website. Follow these instruction to create a PHPMyAdmin backup. Step 1: Log into your cPanel. Locate and click on "phpMyAdmin." Step 2: Once you are inside phpMyAdmin, ...
    • How To Use The MySQL Database Wizard

      What is the MySQL Database Wizard? MySQL Database Wizard is a cPanel option that makes it easier and quicker to create a MySQL database and database user than by doing it manually using the MySQL Databases option in cPanel. How do I access the MySQL ...
    • Importing Large MySQL Databases In SSH

      If you have a large database dump ( .sql ) that you cannot upload through phpMyAdmin due to it’s size, the alternative is to upload it to your ftp root and use the command line to import it. You can request SSH access for your domains in the Reseller ...
    • How To Use PHPMyAdmin

      What is phpMyAdmin? PhpMyAdmin is an open source tool written in PHP intended to handle the administration of MySQL databases on the web. It can be used to perform various operations such as creating, modifying or deleting databases, tables, fields ...
    • Can I Reset My Website Files

      When you log into FTP you will see your public_html folder. This folder is where all your site content is located. If you delete everything in your public_html folder this will be your entire website. We recommend creating a backup up your account by ...