[mythtv-users] can't upgrade db

[Tony Bones]

cool, thx for the heads up.  I think the problem was that I switched back to
utf8 before I did the upgrade.  I left my files as latin1 and the upgrade
completed.  I have a few person projects in mysql, but i dont' really care
about them, just as long as myth is working, i'm happy :)


On Wed, Apr 28, 2010 at 7:26 AM, Tom Dexter <digitalaudiorock at gmail.com>wrote:

> On Wed, Apr 28, 2010 at 9:14 AM, Tom Flair <tom at graniteskies.net> wrote:
> > On Wed, Apr 28, 2010 at 1:28 AM, Tony Bones <aabonesml at gmail.com> wrote:
> >>
> >> yea so i think i got it now.  I think i updated the my.cnf before i
> should
> >> have.  i reverted and now mythtv-setup completes the upgrade, but my
> my.cnf
> >> has all character-set lines = latin1.  just wasn't sure if they were
> suppose
> >> to be removed or not.  I thought the sed script was commenting them out.
> >>
> >> anyway, all good ... for now
> >>
> >> thanks for your help
> >>
> >> On Tue, Apr 27, 2010 at 10:21 PM, Michael T. Dean
> >> <mtdean at thirdcontact.com> wrote:
> >>>
> >>> On 04/28/2010 12:57 AM, Tony Bones wrote:
> >>>>
> >>>> what should my my.cnf file have in it?  no character-set lines or
> >>>> character-set lines that are set to latin1 or utf8?
> >>>>
> >>>
> >>> That I can't tell you.  You'll have to either play around with your
> >>> config until you get it right or find some Gentoo user that knows how
> Gentoo
> >>> configures things and have them help you reconfigure it.
> >>>
> >>> Or, use a temporary non-Gentoo system to upgrade your DB--like the
> >>> Mythbuntu approach I mentioned.
> >>>
> >>> Mike
> >>
> >
> > If you are only using mysql for Myth use, try setting the latin1 USE flag
> in
> > your package.use file.  This should insure that in a future upgrade, it
> > doesn't "magically" get set back to Gentoo's default UTF8.
> >
>
> Well...all that really does is to make the compiled in default latin1
> if the my.cnf doesn't say otherwise.  I wouldn't bother with that.  As
> a matter of fact, after the upgrade to 0.22-fixes I switched mine back
> to the original utf8 my.cnf, as MythTV 0.22-fixes works fine that way.
>
> Tom
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100428/adc36fd0/attachment.htm>