Time for action – how to restore the database
Log in to your web host's control panel. Find PHPMyAdmin. Among all of the hosts that are in use, it can be accessed by viewing the list of databases and then clicking on Edit or Manage with PHPMyAdmin. Then a screen very similar to the next screenshot is shown by clicking on the edit link next to the PrestaShop database. All the functions that we carry out in this tutorial will be performed on that specific database.
When you have located PHPMyAdmin or your web host's equivalent, read on.
Open a new browser window or tab. In your web host's control panel, delete the database.
Recreate the database using the same name, username, and password. A potential problem here is that some web hosts do not let you choose the name of a database. Don't panic, just create a new database and proceed with whatever name they give you. An extra step that I point out near the end of this tutorial should solve the problem.
Extract the compressed database backup on...
