You can directly copy a database from one host to another host like this:
$> mysqldump -u SOURCE_DB_user --password=SOURCE_DB_pass -h SOURCE_DB_HOST SOURCE_DB_name | mysql -u DB_user --password=DB_pass -h DB_host DB_name
You can directly copy a database from one host to another host like this:
$> mysqldump -u SOURCE_DB_user --password=SOURCE_DB_pass -h SOURCE_DB_HOST SOURCE_DB_name | mysql -u DB_user --password=DB_pass -h DB_host DB_name