[mythtv-users] MySQL server Crashed and lost shows

[Michael T. Dean]

On 08/22/2011 10:04 PM, Craig Van Tassle wrote:
> I had an external MySQL server and it crashed. I have lost a couple of
> shows that were recorded but had not yet made it in to my backups. I
> was wondering if the was a way to import those recordings into my new
> SQL server.
>
> I know there was a script that would do it but I cant seem to find it.
> My backend is Ubuntu Server 10.10, with MythBuntu repos.
>

The best (and supported) approach is for you to put the shows into 
MythVideo.  And, with MythVideo's support for TV series as well as 
movies and it's metadata support, you can get all the metadata that you 
would have had from the recording (and more) "back".

Then, you can set up MythTV to re-record the episodes if you want them 
in Watch Recordings (chances are, they aren't blocked from recording if 
you restored a backup from before they were recorded, but you will need 
to ensure you still have a recording rule that would capture them).  Or, 
if you're a collector or just want to have the whole season in the same 
place so you're sure you watch them in order, you can move the rest of 
the series to MythVideo, too.

Mike