Encoding problem while upgrading mysql server.

Encoding problem while upgrading mysql server.

by Ivan Belotelov -
Number of replies: 0
Dear database-gurus,
I have a  production server running MySQL 4.1.10a. Now we  are using Moodle 1.5.3+.  Preparing the migration to Moodle 1.6  I've upgraded mysql on the test
server to MySQL 5.0.2-alpha.  All  the other  OS/software  are absolutely uniform  for  this  two  servers.  Here  is the charset  setting we  are running now with:

production:
character set client         koi8r
character set connection koi8r
character set database    koi8r
character set results        koi8r
character set server        koi8r
character set system        utf8
character sets dir            /usr/local/share/mysql/charsets/
collation connection       koi8r_general_ci
collation database          koi8r_general_ci
collation server              koi8r_general_ci

testbed:
character set client        latin1
character set connection latin1
character set database    latin1
character set results       latin1
character set server       latin1
character set system       utf8
character sets dir          /usr/local/share/mysql/charsets/
collation connection      latin1_swedish_ci
collation database         latin1_swedish_ci
collation server            latin1_swedish_ci

I  was  trying to  move the database dump  from  prod.server to testbed.  But  after  importing the DB  from dump  I  got    "????"   where  cyrillic  letters  are expected.

I  have try  to  switch all  the testbed DB  charset  setting to utf8 (via /etc/my.cnf)  and convert  the  dump  with iconv -f KOI8R  -t UTF8,  but
got the same result at the end.

Could  please  somebody help to find the correct sequence of actions  to solve the problem?



Average of ratings: -