[mythtv-users] Database update schema error with trunk utf8

freedenizen freedenizen at gmail.com
Sun Dec 7 20:40:02 UTC 2008


hmm I just tried that, now I get Duplicate entry '' for key 1.  I know
there must be something misconfigured, but I'm not sure where to look.

On Sun, Dec 7, 2008 at 12:13 PM, myShade <myshade at bredband.net> wrote:
> Hi.
>
> I belive i had something similar, going to utf8 from iso???? something.
> I ran mysqldump > mythdump.txt and then ran iconv conversion on the
> dump. Then imported the converted database.
>
> Something like-
> iconv -f iso-8859-1 -t utf-8 mythdump.txt -o mythtv_utf8.txt
>
> Just keep the dump until your sure you got it right.
>
> Br Fredrik


More information about the mythtv-users mailing list