[mythtv-users] Error when changing Mythtv's mysql database from utf8 to latin1 on Gentoo
dliana.mythtv at gmail.com
Wed Nov 11 21:45:28 UTC 2009
On Wed, Nov 11, 2009 at 3:16 PM, Michael T. Dean <mtdean at thirdcontact.com>wrote:
> 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:
>> 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
> 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
> You need to follow the instructions at:
> mythtv-users mailing list
> mythtv-users at mythtv.org
I followed the directions on the posted thread on my end... Started with a
clean v0.21-fixes DB in latin1 charset, upgraded to v0.22, ran the setup...
Will the resulting v0.22 database be utf8?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the mythtv-users