[mythtv-users] Settings table problems

[Michael T. Dean]

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