OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: MySQL upgrade from 3.x to 4.1 for Chinese databases

From: Gleb Paharenko (gleb.paharenkoensita.net)
Date: Sun Oct 02 2005 - 03:29:39 CDT

Hello.

Try to follow the manual. At first you should perfrom an upgrade to 4.0.
If everything is Ok - then move to 4.1. See:
  http://dev.mysql.com/doc/mysql/en/upgrading-from-3-23.html
  http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html

> Yes. I tried. The result is all Chinese words were turned into
> unrecognized characters.

Have a look here:
   http://dev.mysql.com/doc/mysql/en/charset-upgrading.html

Chenzhou Cui wrote:
>
>
> YL wrote:
>
>> Did you tried just copy those 3.23 files into a newly installed 4.1 data
>> folder? What's happen?
>>
>>
>
> Yes. I tried. The result is all Chinese words were turned into
> unrecognized characters.
> In my system, there are tens of databases, which include thousands of
> tables. A very large system, I feel.
>
>> ----- Original Message ----- From: "Chenzhou Cui" <cczbao.ac.cn>
>> To: <mysqllists.mysql.com>
>> Sent: Friday, September 23, 2005 12:40 AM
>> Subject: MySQL upgrade from 3.x to 4.1 for Chinese databases
>>
>>
>>
>>
>>> Dear all,
>>>
>>> On my server there are thousands of database files contenting Chinese
>>> records. The total data volumn is over 20GB. Is there an easy way to
>>> upgrade the whole system from MySQL 3.23.x to 4.1.x?
>>>
>>> "mysqldump" is NOT a good way for me. It will be a hard and time costing
>>> work. Is it possible to directly use the binary db files, "*.frm",
>>> "*.MYI", "*.MYD", and keep the Chinese support? This is a very big and
>>> important problem facing many Chinese users.
>>>
>>> cheers,
>>> Chenzhou
>>>
>>> --

--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __ ___ ___ ____ __
  / |/ /_ __/ __/ __ \/ / Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenkoensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
       <___/ www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql