MySQL Forums
Forum List  »  Newbie

Mysqldump problem
Posted by: Eugene van den Hurk
Date: August 30, 2004 04:04AM


I did a mysql dump of a database between two servers we have using the following command:

mysqldump --opt <db_name> -u <username> --password=<password> | mysql --host=<hostname> -C <db_name> -u <username> --password=<password>

This command seemed to run ok as it transferred all the structure and data from the original server to the new server database.
However, on closer inspection there is a problem. Many characters in the new database are showing up as a a question mark ? (e.g. characters such as ", trademark symbol, and fractions such as 1/3).
If I edit this data using phpmyadmin and replace it with the relevant symbol manually then it is ok.
There are hundreds of instances of these characters in the database and to change them manually would be very time consuming.
Is there and option regarding character sets I can set in the mysqldump that might solve this problem?
Any help would be appreciated.


Options: ReplyQuote

Written By
Mysqldump problem
August 30, 2004 04:04AM
August 30, 2004 10:41AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.