MySQL Forums
Forum List  »  Russian

Re: Upgrade to MySQL 5.0
Posted by: Andrei Toutoukine
Date: September 14, 2006 09:02AM

Solution is found.

The upgrade to MySQL5 went wrong way and all the data in the tables were already "twice encoded" to the moment I experience troubles with my web-application.

Great confusion appeared because of the default settings (for example character_set_results=latin1): MySQL server was forced to convert the data in tables (as if they were utf8) to latin1. That's why client received correct utf8 data.

New version of the web-application changed to the correct values of "character_set_%", and the data were sent to it as is.

How did I manage this problem? Shortly speaking, I dumped wrong-encoded data wrong way, obtaining them back in utf8:

mysqldump --opt -v --default-character-set=latin1 -u dbuser -p database > database.sql

Then I replaced all occurences of the 'latin1' string with 'utf8' in the file database.sql.

After that I recreated the db:
drop database database; create database database character set utf8;

And, finally, fed the data back to the server:

mysql -u dbuser -p database < database.sql

Options: ReplyQuote

Written By
September 13, 2006 08:37AM
Re: Upgrade to MySQL 5.0
September 14, 2006 09:02AM
October 04, 2006 04:30AM
March 04, 2008 04:59AM
May 05, 2008 03:17AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.