MySQL Forums
Forum List  »  Replication

Re: Require suggestion for changing character set in Master master replication setup
Posted by: Satish Kumar P
Date: December 30, 2009 12:04AM


Application is already using utf8 for all interactions with DB.

So, I can use something similar to the following right?

mysqldump --default-character-set=latin1 <db-name> > dmp-file
perl -i -pe 's/latin1/utf8/' dmp-file
mysql --default-character-set=latin1 <db-name> < dmp-file

Options: ReplyQuote

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.