Copying table to another server.

[Andrew Mull]

Hello,

I'm having a problem with moving a database from one server to another using 
mysqldump.  Since the servers are different platforms, some ascii characters 
are getting corrupted.

So, my thought was to copy the table from one database to the other via the 
mysql interface.

I found this online at mysql:

mysqladmin -h 'other_hostname' create db_name
mysqldump --opt db_name | mysql -h 'other_hostname' db_name

However, all it does is hang...so I'm guessing its a permission problem?

Any suggestion to how to setup this up so it works or is there an easier way?

Thanks!
-Andy