[ILUG] Problem with mysqldump

[Eugene van den Hurk]

Hi Padraig,

Thanks for the help, hope you are feeling better.
It definitely looks to be the problem with the language environment on both 
servers alright.
(btw old server is running Red Hat Linux 7.3 and the new server is running 
CentOS Linux).
I ran locale on both servers and the old server gave:
LANG=en_US.iso885915

Whereas the new server gave:

LANG=en_US.UTF-8

I will try to convert the mysql data on my existing mysql server to utf-8 
and redo the mysqldump.
However, looking at /usr/share/mysql/charsets on the old server I do not 
see utf-8 listed.
So I'm wondering is utf-8 supported on my existing mysql server.
If not, I see some other things I might be able to try from the link you 
forwarded me in your previous email.
I'll let you know how I get on.

Thanks,
Regards,
Eugene.
At 10:10 01/09/2004, you wrote:
>I should also add that you should use utf-8 where possible.
>I.E. the prefered solution would be to convert your iso-8859-1
>data in mysql to utf-8 assuming your version of mysql is
>OK with that of course.
>
>--
>Pádraig Brady - http://www.pixelbeat.org
>--- Following generated by rotagator ---
>
>If you don't select "System clock uses UTC" then the time
>will not be automatically adjusted for daylight savings etc.
>--

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

Tel: +353 21 4279517