[mythtv-users] Full or Partial Database restore?

John Haywood john at jhit.com.au
Tue Sep 14 17:41:16 UTC 2010


On 15/09/2010, at 3:18 AM, Michael T. Dean wrote:
> On 09/14/2010 09:04 AM, John Haywood wrote:
>> After much instability going from Mythbuntu 9.10 to 10.04, even trying a database backup, clean install and restore the inevitable finally happened:
>> 0.23.1 fixes, PPA repo
>> 
>> I was experiencing several freezes and lockups, usually one or two per day.
>> 
>> 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)
>> I ran the db optimise script to check, then the mysqlcheck, as per the wiki
>> mysqlcheck found problems which it repaired
>> 
>> 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
>> 
>> 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
>> 
>> 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?
>> 
>> Or should I just do a partial restore from the last backup
> 
> 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.
> 
> http://www.mythtv.org/wiki/Database_Backup_and_Restore#Database_Restore
> 
> 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.

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 ....

cheers
John Haywood
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100915/96a06378/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3913 bytes
Desc: not available
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100915/96a06378/attachment-0001.bin>


More information about the mythtv-users mailing list