We learned the way how to restore MySQL database from sql dump file. Let’s review the way how to do the same task with phpMyAdmin. To restore (import) a database via phpMyAdmin, first choose the database you’ll be importing data into. This can be done from the corresponding menu on the left.
Then click the Import tab:
You have the option of importing an .sql file. Choose the file from your local computer. Note that you are given 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.
In order to start the restore click on the Go button at the bottom-right. A notification will be displayed upon a successful database import.