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]