File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)

[Duboux]

I got a new machine, and used custombuild to install and upgrade to the latest MySql 5.0.

Now it gives me:

File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Character set '#48' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file

Googling for it end up on a years old bug-page from MySql, where nothing was done about it.

 

[smtalk]

Is it a Debian server? If yes, try:

mv /etc/mysql/my.cnf /etc/mysql/my.cnf.debian
ln -s /etc/my.cnf /etc/mysql/my.cnf
/etc/init.d/mysqld restart

 

[Duboux]

Thanks for replying

it's a Cent0s 5.2 64bit

 

[daveyw]

it's a Cent0s 5.2 64bit

We have also alot of CentOS 5.x 64bit systems and upgraded without any problems.

 

[Duboux]

The error also speaks of character set "48"
But my /usr/share/mysql/charsets/Index.xml file contains:

<collation name="latin1_general_ci" id="48">
<order>Dutch</order>
<order>English</order>
<order>French</order>
<order>German Duden</order>
<order>Italian</order>
<order>Latin</order>
<order>Portuguese</order>
<order>Spanish</order>
</collation>

I got a hunch that MySql ain't compiled with latin, and instead with utf-8 on this machine.
Even though it says in /etc/my.cnf:

collation-server=latin1_general_ci

And I can't locate the file "latin1_gereral_ci", but can find: "/usr/share/mysql/charsets/latin1.xml"


/me looks further..