[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
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
More information about the mythtv-users
mailing list