How to restore your MySQL database from a backup with phpMyAdmin

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:

PhpMyAdmin Import

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.

PhpMyAdmin Import Encoding

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.

2 thoughts on “How to restore your MySQL database from a backup with phpMyAdmin

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>