Step 1: To restore a database via phpMyAdmin, first choose the database you’ll be importing data into. This can be done from the menu on the left.
Step 2: A new page will be loaded showing the structure of the selected database. To import data inside the database, click the Import tab.
Step 3: On the new page that opens, click the Browse button and select the backup that you want to import from your local computer. You have the option to pick the character set of the file from the drop-down menu just below the upload box. If you are not certain about the character set your database is using just leave the default one.
Step 4: Click the Go button to perform the import.
Step 5: The import will start and once finished you will be redirected to a page with a confirmation notification that the import was successful.