[ILUG] Problem with mysqldump

[Eugene van den Hurk]

Hello,

Have a little bit more info. on this problem, which I should have included 
in my initial post...
Just to recap:
##############################################################################
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.
##############################################################################
New info:

The difference between versions of mysql on both servers are not that 
different:
3.23.58 - new server
3.23.52 - old server
I got the status information when I logged into mysql on both servers, and 
it showed that they are both using the same character sets.
Client characterset:    latin1
Server characterset:    latin1

According to the documentation, mysqldump in these versions dumps using 
latin1 character set by default.
I did a dump of the database locally on the old server using the following 
command:
mysqldump --opt <db_name> -u <username> --password=<password> | mysql -C 
<db_name_bak> -u <username> --password=<password>
I made a copy of the web site and pointed it at db_name_bak and all the 
characters in question displayed ok.
So it does not look like a problem with the mysqldump output.
It does look like there is some configuration issue on the new server 
regarding mysql, or maybe even php or apache, that is causing this.

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