<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div>On 15/09/2010, at 3:18 AM, Michael T. Dean wrote:</div><blockquote type="cite"><div> On 09/14/2010 09:04 AM, John Haywood wrote:<br><blockquote type="cite">After much instability going from Mythbuntu 9.10 to 10.04, even trying a database backup, clean install and restore the inevitable finally happened:<br></blockquote><blockquote type="cite">0.23.1 fixes, PPA repo<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">I was experiencing several freezes and lockups, usually one or two per day.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Finally the whole box just started up to a setup screen - and refused to update the schema from<blank> to 1025 (i.e. no value to current)<br></blockquote><blockquote type="cite">I ran the db optimise script to check, then the mysqlcheck, as per the wiki<br></blockquote><blockquote type="cite">mysqlcheck found problems which it repaired<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">I then thought I'd check the xfs filesystem on which the recordings are stored and found quite a few orphaned files, which it placed in Lost + Found<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">I'm now faced with reinstalling the OS, and restoring the db from a backup. I'd like to keep my database of recordings, videos and schedules if possible, but if I have to lose the rest, I can live with setting the combined fe/be up again<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Should I try a full restore from a couple of days before the final crash first - or am I just prolonging the agony given the previous issues?<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Or should I just do a partial restore from the last backup<br></blockquote><br>There's really no benefit to doing a partial restore if you have a good backup of a non-corrupt schema. The partial restore can be useful if someone broke the schema. Otherwise, it's just the same end result as a full restore, except you have to reconfigure /everything/ after the fact, and you lose some useful data.<br><br><a href="http://www.mythtv.org/wiki/Database_Backup_and_Restore#Database_Restore">http://www.mythtv.org/wiki/Database_Backup_and_Restore#Database_Restore</a><br><br>In all the cases where people claim that their systems run faster/better after a partial restore, it's either a) they had never used optimize_mythdb.pl in their lives or--far more likely--b) they did a complete operating system re-install, and /that/ made things run faster/better.<br></div></blockquote><br></div><div>This I understand, and thanks for the advice. What i'm concerned about is the quality of the backup, and hence the restore I guess ....</div><div><br></div>cheers<br><div>
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0; "><div>John Haywood</div></span></div></body></html>