[mythtv-users] Error when changing Mythtv's mysql database from utf8 to latin1 on Gentoo

[Michael T. Dean]

On 11/11/2009 11:38 AM, Steve Evans wrote:
> I am using Mythtv 0.21 on Gentoo. Gentoo sets up mysql to use utf8,
> but Mythtv prefers it to use latin1. This will cause problems when
> Mythtv is upgraded to 0.22. There are instructions on how to fix this at:
>
> http://wiki.mythtv.org/wiki/Fixing_Corrupt_Database_Encoding
>
> I followed these instructions, but got this error when restoring the fixed 
> backup:
>
> ERROR 1062 (23000) at line 1712: Duplicate entry 'Kathleen ÃôDixieÃö 
> Dixon*Jane Hazlegr' for key 2
>   

That means you have partial corruption.

> Fortunately it was possible to restore the original, unfixed, backup,
> so I have a working mythtv :-)
>
> Does anyone have any idea how to fix the database /without/ getting this 
> error?

You need to follow the instructions at:

http://www.gossamer-threads.com/lists/mythtv/users/406111#406111

Mike