How to restore your MySQL database from a backup:MySQL Import?

To restore (import) through phpMyAdmin database, you first select the data into the database. This can be accomplished from the corresponding menu on the left. Then click the "Import" tab:

MySQL Import?
You can choose to import the sql file. Select the file from your local computer. Please note that you upload box below the drop-down menu of options to pick the document character set. If you are not sure your database uses the default character set just leave.

MySQL Import?
Click the Go button to start recovery in the lower right corner. Successful database import, it will display a notification.