It should just exit unless you are using -p with mysql. In that case, if mysqldump got an access denied, nothing would output to stdout and mysql would be left waiting for a password.
I would try the following: >mysqladmin -h 'other_hostname' create db_name >mysqldump --opt db_name > dump.sql >mysql -h 'other_hostname' -D db_name < dump.sql Running the commands separately will allow you to see what is going on more easily. You may need to specify a username and a password with each command i.e. 'mysql -u user -p'. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -----Original Message----- From: Andrew Mull [mailto:[EMAIL PROTECTED] Sent: Thursday, January 06, 2005 11:17 AM To: mysql@lists.mysql.com Subject: Copying table to another server. 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
