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

[Michael T. Dean]

On 06/26/2013 11:09 AM, Michael T. Dean wrote:
> On 06/26/2013 10:42 AM, John Veness wrote:
>> 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.
>
> Right, and using find_orphans.py is the easiest way to identify the 
> new recording files.
> http://www.mythtv.org/wiki/Find_orphans.py

Oh, and you may want to consider moving other episodes of the same 
series to Video Library, too.  In this case it would help put together 
the whole series, but in other cases, it just makes a much easier to 
organize and navigate UI than Watch Recordings if you have a lot of videos.

http://www.gossamer-threads.com/lists/mythtv/users/519758#519758
http://www.gossamer-threads.com/lists/mythtv/users/519996#519996

Mike