Once you have taken the dump of the database then you can restore using the dump.sql files(learn here to take the dump/back-up from database).

In phpMyAdmin simply click on the SQL tab and then from there you can browse the dump.sql file that you have stored after taking the dump. If the structure is not there then first of all import the structure file which will create the structure of the table and later you can import the dump.sql file which is having the data.

Through phpMyAdmin it that simple. If you find any problem in importing the whole file. Then you can cut and paste the queries and populate them in the database.

Through the command prompt you can simply use these commands to restore the database. First of all go to the directory where the dump.sql file is stored and from there run these commands:

mysql -u USERNAME -pPASSWORD DATABASENAME dump.sql

Put the less than sign between DATABASENAME and dump.sql

This command will populate the dump in your database and then you will have your data back in your application.