<font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#007777">>>> Note that the partial restore instructions state that, "A partial <br>
>>> restore...is primarily useful as a last-resort when some of the data in the <br>>>> database is corrupt (or, more precisely, a 2nd-to-last resort--as starting <br>>>> over from scratch would be a true last resort). In general, do not do a <br>
</font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#007777">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#007777">>> partial restore--instead do a full restore." Please do not even consider <br>
></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#007777">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#007777">> doing a partial restore until you completely read and understand <br>
></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#007777">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#007777">> <a href="http://www.mythtv.org/wiki/Database_Backup_and_Restore#Partial_restore_of_a_backup" rel="nofollow" target="_blank">http://www.mythtv.org/wiki/Database_Backup_and_Restore#Partial_restore_of_a_backup</a> <br>
></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#007777">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#007777">> . <br>
></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#007777">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#007777">> <br>
></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#007777">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#007777">> Then, once you understand that section, do a full restore as mentioned <br>
></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#007777">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#007777">> above. Cleaning up your OS, then cleaning your Input Connections ( <br>
></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#007777">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#007777">> <a href="http://www.gossamer-threads.com/lists/mythtv/users/264034#264034" rel="nofollow" target="_blank">http://www.gossamer-threads.com/lists/mythtv/users/264034#264034</a> ) will give <br>
></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#007777">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#007777">> you a very clean/fast MythTV system. <br>
></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#007777">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#007777">> <br>
</font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">> While I agree that there are few reasons that a properly maintained <br>
</font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">> myth system should ever need to use a partial restore... there are <br>
</font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">> reasons why one might want to use it. <br>
</font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">> <br>
</font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">> I like to start from a clean slate every now and again. I often find <br>
</font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">> that I make changes to the system to suit my needs one time... then <br>
</font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">> forget about it... those changes will often come back to haunt me. <br>
</font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">> Starting with a fresh DB allows me to go through and reconfigure <br>
</font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">> everything the way I want it going forward knowing that nothing I did <br>
</font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">> in the past will make my life difficult. <br>
</font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">> <br>
</font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">> It's kinda like reloading windows (for those of us who still have to <br>
</font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">> do that). Sure you could probably fix anything that is bothering you, <br>
</font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">> but sometimes starting clean and spending a couple of days setting <br>
</font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">> things up exactly the way you want them puts you in a better position <br>
</font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">> going forward, while also clearing up any issues that you may have <br>
</font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">> created for yourself in the past. <br>
</font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">> <br>
</font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">> I agree that there are some concerns... but if, like me, you spent a <br>
</font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">> version or two getting the feel for myth and now you want to get <br>
</font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">> 'serious' and start clean, a partial restore is a good way to do that. <br>
</font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">></font></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="#660066">> <br>
</font> <br>> No. The right way to "start clean" is to reset the settings to <br></font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2">> </font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2">defaults. The right way to do that is to click the button that resets <br>
</font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2">> </font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2">the settings to the defaults. (This button does not yet exist.) <br>
</font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2">> </font></font><br><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2">> </font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2">Basically, a partial restore is throwing out the baby with the bath <br>
</font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2">> </font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2">water. You're going through a ton of trouble, and all you're <br>
</font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2">> </font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2">accomplishing is resetting settings to their defaults (and losing a ton <br>
</font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2">> </font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2">of useful information in the process). I plan to add the ability to <br>
</font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2">> </font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2">reset settings to defaults. I just have to get time to do it. <br>
</font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2">> </font></font><br><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2">> </font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2">Mike<br>
<br>First off, I apologize that I'm breaking the message threading. I had digesting turned on, but didn't want to wait until tomorrow morning to reply. <br><br>I totally get that, </font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2">Mike. </font></font><font color="black" face="Verdana,Arial,Helvetica" size="2"><font color="black" face="Verdana,Arial,Helvetica" size="2">Yes, a "return to defaults" button would be GREAT. That's exactly what I need. Here's the full backstory:<br>
<br>I had a perfectly functional Myth .20 box, on Gentoo. Built it a couple years ago, upgraded to .21-fixes via portage, continued to work great. Then I did something stupid and broke the dependency chain, causing mythfrontend to segfault. I tried to fix it, but I had let my Gentoo box get too out-of-date and ran into all sorts of issues with the Gentoo profile. Since there was growing unrest within my user community (ie, my wife), I punted, backed up the DB, wiped the OS and started fresh with Myth .22-fixes. I reimported the MySQL DB, did the schema upgrade & all my recordings & channels were there. Crisis averted.<br>
<br>However, it isn't all perfect. The phantom tuners and whatnot are only the tip of the iceberg. Other settings seem to have no effect when I toggle them--things that worked fine in .21, such as the "Live Preview of Recordings". <br>
<br>But there was a lot of stuff like that. I assumed it was because of the strange life my DB has lived, that maybe the schema upgrade had left a few things out of sync. And since I REALIZE I do not know the inner workings of the Myth DB schema, nuking from orbit seemed a viable option. My comment about my familiarity with MySQL was so that assisting individuals could gauge my skill level. I don't care about speed. It's perfectly snappy today. <br>
<br>Who knows, I may encounter some real bug in the future. If/when that happens, I would like to be able to immediately rule out DB inconsistency as a possible cause. <br><br>Thanks,<br>D<br></font></font>