How to Restore a MySQL Database From a Backup Using phpMyAdmin
In the goal of improving our databases we often destroy it before we are able to fix it. PhpMyAdmin provides you the ability to restore from a backup with very little effort.
How to Restore a database from a backup using phpMyAdmin
Within your hosting control panel click in the “Databases” row click on the icon labeled “phpMyAdmin”. If your not sure how to log into your hosting control panel please visit the article here.
In the database user selection window click on the “Launch” icon associated with the user for the database you are looking to gain access to.
Once phpMyAdmin is opened click on the database you are needing to restore from the left side of the screen under the phpMyAdmin logo.
After you have selected the correct database click on the “Import” menu option located above your tables in the middle of your screen.
Within the Importing into the database window you want to click on the icon “Choose File” to select the file you are wanting to restore from. You will also want to select the character set of the file.
In the Format drop down box select the format of your file that you are uploading to PHPMyAdmin.
Within the Format-Specific Options you can select if any specific SQL compatibility mode that your SQL database may need. Most exports from PHPMyAdmin will use the option “NONE”.
After you have preformed all the needed steps click on the “Go” button to upload your database to your database server.
Once the database has been uploaded to your account you should receive a message similar to the following example: