No one can provide a perfect solution. It seems that this is really a
difficult problem for the MySQL.
YL wrote:
I tried from 4.1 to 5.01, everything works fine without change the data
files.
I used Chinese in both gb and b5 (different columns in the same table)
without
any encoding setting at database level.
So the problem seems in 3.* to 4.*.
If mysqldump worded for you. My suggestion is to write a script to automat
this data conversion.
----- Original Message -----
From: "Chenzhou Cui" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Cc: "YL" <[EMAIL PROTECTED]>
Sent: Friday, September 23, 2005 6:54 AM
Subject: Re: MySQL upgrade from 3.x to 4.1 for Chinese databases
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" <[EMAIL PROTECTED]>
To: <mysql@lists.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
--
============================================================
Chenzhou Cui (China-VO Project)
National Astronomical Observatory | Tel: (8610)64841695
Chinese Academy of Sciences | FAX: (8610)64878240
Datun Road 20A, Chaoyang District | Email: [EMAIL PROTECTED]
Beijing 100012, China | WWW: www.lamost.org/~cb
============================================================
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.4/109 - Release Date:
9/21/2005
--
============================================================
Chenzhou Cui (China-VO Project)
National Astronomical Observatory | Tel: (8610)64841695
Chinese Academy of Sciences | FAX: (8610)64878240
Datun Road 20A, Chaoyang District | Email: [EMAIL PROTECTED]
Beijing 100012, China | WWW: www.lamost.org/~cb
============================================================
--
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.4/109 - Release Date: 9/21/2005
--
============================================================
Chenzhou Cui (China-VO Project)
National Astronomical Observatory | Tel: (8610)64841695
Chinese Academy of Sciences | FAX: (8610)64878240
Datun Road 20A, Chaoyang District | Email: [EMAIL PROTECTED]
Beijing 100012, China | WWW: www.lamost.org/~cb
============================================================
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
