The restore of a full Drupal website backup might be required if something goes wrong with your website and you want to reverse the changes to the last point, when it was fully operational.
The first step that you need to complete is to upload the backup of your Drupal content on your account. This can be done using your favorite FTP client or directly via the File Manager service within your cPanel account. Choose carefully the directory, where you would like your Drupal website to appear and make sure that you remove any previous content that is located within the same directory.
First you need to create an empty database on your account and user for it. This user must have All Privileges to your database.
You can create a new database and a user assigned to it via cPanel. Simply follow our MySQL Wizard tutorial for information on that.
Once you create the new database on your account, you will have to upload the dump backup of your Drupal website. Access your cPanel account again and navigate to the Databases tab and then phpMyAdmin.
Select the database that you have just created from the list on the left-side of the screen.
Click on the Import button from the top-menu.
In the File Import section, you need to select the dump backup file of the database that you wish to restore. When you complete that, simply click on the Go button at the bottom of the screen.
By completing the steps above, you should have a location on your account, which contains all of the files and folders of your Drupal website. You should also have a database, which contains the backup of your Drupal database. Now, it is time to configure them together.
You need to edit the Drupal configuration file on your account and correct the details for your database.
You can locate the name of your database, reviewing our tutorial on how to edit Drupal configuration file.
Congratulations, you have successfully restored the Backup of your Drupal based website.