[mythtv-users] MythTV Disaster Recovery

[Ian Barton]

John Welch wrote:
> I'm almost embarrassed to post this because of some stupidity on my part 
> but here goes... Over the weekend I experienced a somewhat sudden and 
> what looks to be an unrecoverable hard drive crash on my boot / root 
> drive on my MythTV back-end system.  I had a fairly recent database 
> back-up from when I upgraded my system from 0.21 to 0.22 but 
> unfortunately (and foolishly) I left the backup not only on the back-end 
> system, but also on the root drive that crashed.  I dug around my other 
> systems and I did manage to find a previous database backup from earlier 
> in the year when I did a hardware upgrade.  Fortunately (I hope) I did 
> not lose any of my active recordings because they were being saved to 
> either another local drive or an NFS mount on my NAS server.
> 
> So, now I am trying to figure out how to proceed.  My first question is 
> is it worth it to even attempt to use the database backup from earlier 
> in the year?  The biggest thing I dread is re-setting up my channel 
> lineups.  I haven't done much with the channel setup since 0.20 / early 
> 0.21 days, but I remember it to be a fairly time-consuming, very much 
> manual process.  Have things improved in this area so that it would now 
> be a trivial / painless process?  I'm particularly interested in QAM 
> channel scanning for the HDHR and pcHD3000 tuners.
> 
Just a thought, but have you tried booting from a Live CD and trying to 
mount the crashed disk. You may be able to read /var/lib/mysql.

Ian.