[mythtv-users] Settings table problems

Michael T. Dean mtdean at thirdcontact.com
Wed Mar 7 04:07:33 UTC 2007

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.


It's straightforward to go from the above to what you want.


More information about the mythtv-users mailing list