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
mysqldump --opt <db_name> -u <username> --password=<password> | mysql
--host=<hostname> -C <db_name> -u <username>
This command seemed to run ok as it transferred all the structure and data
from the original server to the new server
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.
Eugene van den Hurk
118 Patrick St.
Tel: +353 21 4279517
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!