1) Use phpAdmin:
phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web.
2) Use command line comands mysqldump and mysql:
a) mysqldump -uuser_id -p db_name >db_file, where user_id is the user name for accessing database db_name, and db_file is the file name will hold the structure and data from the database.
b) in the new database server, do this:
mysql -uuser_id -p db_name <db_file
Before doing this, make the you have created a new database named db_name with the user_id and password.
[01/10/2010, 05:33]