Hello,
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.
Thanks,
Regards,
Eugene.