Backup MySQL Database Using Backup Wizard in cPanel

You can easily backup your MySQL database from cPanel by following the below steps:

1. First of all, log into your cPanel account.
2. Navigate to the FILES tab and click on Backup Wizard.
   

    

    

   
   

3. Select the Back Up option as you want to create a backup.

    

   
   

4. In the second step, it’ll ask you to select the backup type. Click over the MySQL Databases option as you want to create a separate backup for your MySQL files.

    

   
   

5. At the final step, you’ll see a list of MySQL Databases present inside your cPanel. Simply click over the database you want to download and it’ll start downloading automatically.

    

   
   

6. It’ll take some time to download the database (depending upon your Internet speed & database size).

That’s It.

You’ve successfully downloaded the partial backup of your desired MySQL databases. Now, let’s move ahead to the restoration process.

Restore MySQL Databases using Backup Wizard in cPanel

It’s fairly simple to restore the MySQL backup using the Backup Wizard in cPanel. Additionally, it’ll be easier for you if you’ve created the backup from backup wizard itself. Follow the below steps to do so:

1. First of all, log into your cPanel account.
2. Navigate to the Backup Wizard section.
   

   Also See: Disable Restrict Mode on Server

3. This time, click over the Restore option instead of Back Up as you want to restore the MySQL backup.

    

   
   

4. It’ll ask you to select the Restore type. There are three options that are Home Directory, MySQL Databases, Emails & Filters. You can choose the option according to your restoration type. For example, hit the MySQL Databases button to restore the databases. Likewise, if you want to restore the backup of your home directory, you can select Home Directory option.

    

   
   

5. In the final step, browse the MySQL database using Choose File button and hit the Upload button to restore it.

    

   
   

6. Once the database is selected, hit the Upload button.

    

   
   

7. Once you hit the Upload button, you’ll see the below message.
   

   Determined database name from sql

   Restoring database “getintod_wp720”

   Done!

8. That’s It. You’ve successfully restored the MySQL database.

You’ve successfully created the MySQL backup and restored it using the Backup Wizard in cPanel. However, other than this, you’ll have to Add User to Database and assign the privileges. Otherwise, your website will through a MySQL error.

Adding User to Database in cPanel

Well, it’s not that hard to add users to the database and assign privileges to them. You can use the following steps to easily add users to cPanel database.

1. Log into cPanel.
2. Navigate to the MySQL Databases section located inside the DATABASES tab.

    

   
   

3. Scroll down to Add User to Database section and select the user & database. Hit the Add button to move to the next step.

    

   
   

4. Assign All Privileges to the database and hit the Make Changes button.

    

   
   

5. You’ll see a popup alert that the user is successfully added with all the privileges.