[mythtv-users] Settings table problems

[Mitch Gore]

Thanks for the pointer.  I ended up just searching my backup with vi and
removing all the other tables info.  That way i just droped the settings
table and recreated it.

Worked like a charm

Thanks anyway...
Mitchell

On 3/6/07, Michael T. Dean <mtdean at thirdcontact.com> wrote:
>
> On 03/06/2007 06:05 PM, Mitch Gore wrote:
> > So i was messing with the database trying to turn XvMC on only for
> > HD.  Which i got to work.  Then i decided to remove it.  I was like ok
> > ill just put the "1" to "0" so i did...
> >
> > update settings set data='0';
> >
> > and you know what happened everything when to 0 in data! I forgot my
> > where clause!
> >
> > Anyway to fix this...
> >
> > I was thinking i would just import my backup that i have from last
> > night.  BUT i was thinking maybe it would just be easier to import the
> > settings table only.  How can i do this.
> >
> > I have my backup command run once daily by cron.
>
> http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7
>
> It's straightforward to go from the above to what you want.
>
> Mike
> _______________________________________________
> 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/20070306/50cf0c25/attachment.htm