[mythtv-users] Full or Partial Database restore?

John Haywood john at jhit.com.au
Tue Sep 14 13:04:50 UTC 2010


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

regards
John Haywood

-------------- 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/20100914/54fbca7f/attachment.bin>


More information about the mythtv-users mailing list