How to Restore SQL Backup (5 Steps)

Log in to your web hosting CPanel or equivalent. This will vary depending on your host. A common example is http://www.yoursite.com/cpanel. If you do not have these details, you will need to contact your web hosting provider.
On your hosting CPanel, find the section labeled 'Databases.' Click the icon marked 'phpMyAdmin.'
Select the name of the database you wish to restore from the list of databases on the left side of the phpMyAdmin screen. In this example, the database is named '_test.'
Select the option marked 'Import' that is above the details of your database.
On the import page, press the 'Browse' button, and locate the SQL backup file from which you will be restoring. Compression will be automatically detected. Once the backup file is selected, press 'Go.' The backup may take some time to import successfully.
VPS Hosting