This article applies to 123-reg VPS hosting running cPanel
This article will explain how you can restore your database through cPanel.
Login to cPanel customer interface.
Under the Databases section, click on the phpMyAdmin link.
You will now be logged into your phpMyAdmin.
Click on the Import button.
Then click on the Browse button, find your backup file and click Open.
Once selected click on the Go button to restore your database.