I have a an old mysql 4 database 开发者_如何学编程with latin1 character set wtih content in Cyrilic, that I need to migrate in mysql 5 with utf8. When I make the mysql dump I see strange characters and I can make a prorper recovery.
Any help?
You need to make a dump with the parameter --default-character-set set to the value of the source database (latin 1), change the charset od the db and tables in the txt file and the restore it with the charset of the target database (utf8):
Here is the procedure how to do it:
http://itworkarounds.blogspot.com/2011/07/mysql-database-migration-and-character.html
精彩评论