MySQL Forums
Forum List  »  Replication

Re: Require suggestion for changing character set in Master master replication setup
Posted by: Satish Kumar P
Date: December 29, 2009 10:44PM

Thanks for the suggestion, Rick.

One quick question: How do I find out whether there are any "8 bit bytes" in any column in a table or not? Is there any Mysql command that provides this info. for all columns in a table?

I did a check of assigned 'character set' for all the tables - it is 'latin1'.

Also, In the mean while I spent some time reading several related questions in forums. Few people in forums suggested the following procedure. But I would like to know whether it is safe way to do??

1. Stop the application, so no more writes to DB
2. Take a mysqldump of DB by specifying the default character set as 'latin1'
3. Update all instances of 'latin1' to 'utf8' in the dump file
4. setup a new mysql instance with default character set as 'utf8'
5. Import the dump file into the new mysql instance
6. Re-point the application to the new DB instance

Thanks,
Satish

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.