[mythtv-users] Database woes - Add a new entry

[John Veness]

On 26/06/2013 15:36, James MacKenzie wrote:
> Here's my story of woe...
>
> I made a backup of my linux box.  I was attempting to use it as a starting
> point on another Myth box I was setting up for a relative.  During this
> process, I got confused as to which machine I was on and did an 'rm
> /usr/lib/mysql' on my good setup.
>
> I was able to go back and get everything working again by grabbing the
> /usr/lib/mysql directory from the backup, but it had been made about 3 days
> earlier.  During this time, about 5 programs were recorded.
>
> So, my question is, is there an easy way to get these entries into the
> database?
>
> Thanks!

You were lucky it was only five recordings in those three days!

I think the usual answer is to view the "orphan" recordings in the Video 
section, if you can identify the filenames and move the correct files 
into your videos folder. Trying to artificially insert data into the TV 
database tables is tricky and not supported. Note that this will mean 
that Myth doesn't "know" it has recorded those particular episodes and 
so may record them again if they're repeated, but that isn't usually a 
big problem.

Cheers,

John

-- 
John Veness, MythTV user, UK, DVB-T