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

Michael T. Dean mtdean at thirdcontact.com
Wed Nov 11 20:16:44 UTC 2009

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:



More information about the mythtv-users mailing list