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

[Steve Evans]

Hello,

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

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?

Steve
-- 
____________________________________________________________________
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