I agree with "niggles".
1) Log into phpadmin
2) If it opens right into your database good - if not click on the database you want to export.
3) In the home section of phpmyadmin you will see a link to "EXPORT" if you do not see this look for a picture of a house.
4) In the "EXPORT" section the first group you see is all the different ways of exporting your database (I personally just check "SQL" at the bottom.
5) Again this is a personal preference but - I just hit "GO". The program will open a new page with all the database contents in it - even with the "CREATE" table fields. I then just cut and paste into where I am going to save it. Or in your new database click on the "SQL" tab. The page will open up with a white box and then you can paste all that data and your database will be created.

-------

You can at the bottom check off the "SAVE" button and name the file which will save it to your computer.
I do hope you are using phpmyadmin and can use this, it will save you sooooo much time.

All you will have to do is drop info in the "SQL" tab and then in your code connect php to that database.