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

James MacKenzie mst3000 at newsguy.com
Thu Jun 27 14:45:22 UTC 2013


At Wed, 26 Jun 2013 11:23:13 -0400 (EDT), you wrote
>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

Thanks to both of you for your answers...I guess putting them into the Video
section will be the best way to go.

As to backing up the DB, I'm normally much better at it...this was a special
one-off thing I was trying to get done for a relative and I was having all
sorts of problems with it, getting all frustrated, which is what caused the
issue with me deleting the directory on the wrong machine in the first place.

Again, thanks for the responses.

----



More information about the mythtv-users mailing list