phpMyAdmin is definitely a good way to go - I also often use it for making backups of databases in case something ever happens at the hosts end.

You should have an option in your Control Panel to acces phpMyAdmin.

Go into "export" and select which tables you want to export - probably all of them I guess - and then save as a .zip or .gzip file.

Open up phpMyAdmin on the new site and "import" the file and it will auto-magically create the tables for you.

Cheers,
Niggles.

__________________
-------------------------------------------------
World Music World - bringing the World's Folk Music Cultures Together
http://www.worldmusicworld.com/
-------------------------------------------------