Posted: May 14th, 2018
Using phpMyAdmin, follow the steps below to restore a MySQL database.
1) Log into your phpMyAdmin:
2) Click Databases and select the database that you will be importing your data into.
3) You will then see either a list of tables already inside that database or a screen that says no tables exist depending on your setup.
4) Click the Import tab at the top.
5) On the next screen will be a Location of Text File box, and next to that a Browse button.
6) Click Browse. Locate the backup file stored on your computer.
7) Make sure the SQL radio button is checked.
8) Click the Go button.
9) A Success screen will appear upon completion.