How do I restore my MySQL database?

Start by accessing your Web Hosting dashboard.

On your dashboard, select the cPanel Admin button that appears above Settings.

Select Backup Wizard from the Files section.

Select the Restore option.

Select MySQL Databases from the Select Restore Type heading.

Select Browse under the ‘Restore a MySQL Database Backup’ option.

Find and choose the backup SQL file on your computer. This will typically be a .gz file.

Select Upload to start the process.

Start by logging in to your legacy Control Panel. For details on how to do this, please read the following article: How do I access and manage my products?

From there, select Web Hosting or Premium Hosting within the ‘Manage active products’ section, depending on which product you wish to use.

Next, select Manage opposite the ‘(bought before XX/XX/XX)’ option.

This will show you an overview of your current hosting packages. Click Manage for the account you wish to use.

On the next page, select Manage for the domain you wish to update.

Click on the MySQL Database link in the Web Tools section of your hosting control panel.

In the Manage Databases section enter the new password in the empty field and press the Modify button.

Click on the database name in the left hand frame.

Click on the Import tab.

In theFile to import section, press the Choose File button.

Navigate to the file you wish to import on your computer and press the Open button.

Click on Go to upload the file.