[ILUG] Mysqldump problem

[Eugene van den Hurk]

Hello,

Had a look on linux.ie to subscribe to a mailing list but could not find 
link, so I thought i'd send to this address.
Apologies if this is not the correct procedure.

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.

------------------
Eugene van den Hurk
Rocket Media
118 Patrick St.
Cork.
http://www.rocketmedia.ie

Tel: +353 21 4279517