Go Back   Forum Care Forums > Development Reference Area > MySQL Discussion

Reply
 
LinkBack Thread Tools Display Modes
Character set problem when upgrading to mysql 5.0x,suggestion needed~
Old
  (#1)
Jayz
Guest
 
Posts: n/a
Default Character set problem when upgrading to mysql 5.0x,suggestion needed~ - 06-04-2007, 07:49 AM

Here's the scenario,it's a lil bit long:
I use mysql 4.0.16 for my working DB, one day i found that sometimes
when inserting a record into the db it reports primary key replication
error. then I found the reason for this: my primary key column stores
data which is in gb2312 charset and mysql was compiled with latin1 as
the default charset. so there's occasion that when i insert a record
with a supposed-to-be distinctive primary key,it reports the primary
key does already exist due to the charset reason.So I mysqldump my data
out and recompile mysql with charset of gb2312 and reimport the data.
BTW,when i mysqldump the data i didnt specify any charset option with
mysqldump.

now here's the problem, I see the bug report saying that there a bug in
4.0.x when using binlog try to recover the DB regarding to multibyte
characters and yes i did have that problem all the way...that's why i
needed to upgrade my mysql to 5.0.x. Does any one have any suggestion
how should I dump my data out of 4.0.16 and recover it back to mysql
5.0.x and still make the charset works? i'm a lil confused about the
charset... any suggestion is highly appreciated! Looking forward to
your answer

   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Contact Us - Forum Care Forums - Archive - Top