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. <br><br>Worked like a charm<br><br>Thanks anyway...
<br>Mitchell<br><br><div><span class="gmail_quote">On 3/6/07, <b class="gmail_sendername">Michael T. Dean</b> <<a href="mailto:mtdean@thirdcontact.com">mtdean@thirdcontact.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On 03/06/2007 06:05 PM, Mitch Gore wrote:<br>> So i was messing with the database trying to turn XvMC on only for<br>> HD. Which i got to work. Then i decided to remove it. I was like ok<br>> ill just put the "1" to "0" so i did...
<br>><br>> update settings set data='0';<br>><br>> and you know what happened everything when to 0 in data! I forgot my<br>> where clause!<br>><br>> Anyway to fix this...<br>><br>> I was thinking i would just import my backup that i have from last
<br>> night. BUT i was thinking maybe it would just be easier to import the<br>> settings table only. How can i do this.<br>><br>> I have my backup command run once daily by cron.<br><br><a href="http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7">
http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7</a><br><br>It's straightforward to go from the above to what you want.<br><br>Mike<br>_______________________________________________<br>mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br></blockquote></div><br>