How to restore your MySQL database from a backup

MySQL Import:

How to restore your MySQL database from a backup

To restore (import) a database via phpMyAdmin, first choose the database you'll be importing data into. This can be done from the drop-down menu on the left. Then click the Import tab:

You have the option of importing an .sql file. Use the Browse button to find it on your local computer. Note that you are given the option to choose 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.