Re: Require suggestion for changing character set in Master master replication setup

[Satish Kumar P]

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