Export and Import of a database...

[binomonkey]

..I'm using "EMS SQL Manager 2007 for MySQL" to create my databases. Now, I want to export a database to the newly created one on hostmonster. What's the easiest way to do this? What I have done so far is create a database through the CP.... then create a table and then import the text script that I saved out from "EMS..." I'm thinking there is a better way to do all this. Seems like I'm recreating the same database and doing double the work here.
If you are not familiar with the MySQL manager I'm using then could you please explain this workflow conceptually.
Thanks much

[pghcollectibles]

do you already have the database in an .sql file? if so you can use phpMyAdmin from the cpanel and inport the complete database that way. the database name cannot exist or you will get an error. make sure you back anything up if you have data in your db that you have already started. i had some problems creating from scratch and i found it was pretty easy to export, save my file as sql type then edit, save delete or rename existing db then inport the sql back in. i think this sounds similar to what i did. if you need specifics just ask but thats pretty much it