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

Steve Evans mythtv-users at gorbag.com
Wed Nov 11 16:38:31 UTC 2009


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:


I followed these instructions, but got this error when restoring the fixed 

ERROR 1062 (23000) at line 1712: Duplicate entry 'Kathleen ├├┤Dixie├├ 
Dixon*Jane Hazlegr' for key 2

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 

Steve Evans            E-mail: mailto:stevee at gorbag.com
                       WEB:    http://www.gorbag.com
Registered Linux user #217906: http://counter.li.org
Public Encryption Key:         http://www.gorbag.com/public-key.html

Now playing: 'Everything's Gone Green' by 'New Order' from the album 'Factory 
Records - Communications 1978-92 - CD2 1981 to 1984'

2.6.30-gentoo-r7 Intel(R) Pentium(R) 4 CPU 3.00GHz GNU/Linux

 11:56:33 up 16 days, 20:51,  7 users,  load average: 1.92, 0.92, 0.37

From the cradle to the coffin underwear comes first.
		-- Bertolt Brecht

More information about the mythtv-users mailing list