How to Restore a MySQL Database

You can restore a MySQL database using either MySQL Workbench or phpMyAdmin

MySQL Workbench

Before connecting MySQL Workbench to your database, you will need to download it.
https://dev.mysql.com/downloads/workbench/
https://support.discountasp.net/kb/a880/how-to-connect-to-mysql-using-mysql-workbench.aspx

Open Workbench, click Server --> Data Import:



Click "Import from Self-Contained File", find the location of the file on your local machine by clicking on the three dots.  Next you will need to choose the target schema, click the dropdown menu and select the one matching the backup file name.  Finally click "Start Import".



The Import will run and your database will have been restored.

phpMyAdmin

You can install phpMyAdmin through the Web App Gallery in the control panel.
https://support.discountasp.net/kb/a1630/installing-phpmyadmin.aspx

Click on the database on the left hand side, then click Import.



Click on "Choose File", locate the backup file usually a .sql file.
Click "Go" .



You should be met with an import successful screen and a restored database.

Please open a support ticket for help if you have any problems or errors.