there are times when you will need to do a msyql dump into your database. this is helpful when you are importing or exporting some data from one site to another or as backups that you have and want to restore.

this short tutorial will show you how you can dump all your data using phpmyadmin.

the first step is to login to your phpmyadmin panel

once you are logged in, select the database where you wan to do the dump

next, all you have to do is select the import tab, or if you are using an older version of phpmyadmin, it will be the SQL tab

there you will find a button that says browse:

then browse through your computer and select the .sql file which you want to dump into your table.

the click the Go Button.

thats it.