[mythtv-users] Adding recordings to DB

[Todd Houle]

Thanks - for future generations searching this list, there is a perl  
script in the contrib dir called "myth.rebuilddatabase.pl" which will  
fix everything up. Thanks for your help Joe!
    -todd-

On Oct 15, 2005, at 4:20 PM, Joe Votour wrote:

> The format of the filename is <channel
> ID>_<startdatetime>_<enddatetime>, where the date/time
> is in ISO8601 format, without the dashes and colons.
>
> There is likely an SQL join using this information to
> reference the show name and description in the SQL
> database.  If this isn't present, then the show can't
> be listed, since there is no useful information to be
> displayed.
>
> I think that somebody may have created a script that
> lets you add the shows with information, but I'm not
> sure.  If you search the archives, you might find a
> pointer to it.
>
> -- Joe
>
> --- Todd Houle <thoule at wesleyan.edu> wrote:
>
>
>> I saw the recorded table, but I didn't see a
>> reference to the file
>> name (1016_20050927010000_20050927030000.nuv).  Is
>> that filename
>> build from other info in that table?  Or is there
>> another table it
>> needs?  I'm not sure how myth locates the files.
>>    Todd
>>
>> On Oct 15, 2005, at 2:38 PM, Nick wrote:
>>
>>
>>> On 15/10/05, Todd Houle <thoule at wesleyan.edu>
>>>
>> wrote:
>>
>>>
>>>
>>>> I recently wiped by Myth box and reinstalled
>>>>
>> everything from
>>
>>>> scratch.  It wouldn't take 2 hours or so, but
>>>>
>> since I was editing /
>>
>>>> etc/modprobe instead of /etc/modprobe.conf, it
>>>>
>> took about 5!
>>
>>>>
>>>> Before I erased, I copied off some of the
>>>>
>> recordings I wanted to keep
>>
>>>> and now I'd like to put them back.  Having the
>>>>
>> exact info isn't
>>
>>>> totally important - program title will do it...
>>>>
>> Which mysql
>>
>>>> databases do I need to make changes to?
>>>>
>>>>
>>>
>>> There's only 1 MythTV database - 'mythconverg'.
>>>
>> You should add the
>>
>>> shows you want back into the 'recorded' table and
>>>
>> make sure you
>>
>>> physically place the files back in the recordings
>>>
>> directory. Not sure
>>
>>> if the thumbnail images will be recreated if you
>>>
>> have deleted those.
>>
>>>
>>> Nick
>>> _______________________________________________
>>> mythtv-users mailing list
>>> mythtv-users at mythtv.org
>>>
>>>
>>
>>
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>>>
>>>
>>>
>>
>>
>>> _______________________________________________
>>>
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>>
>>
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>>
>>
>
>
>
>
>
> __________________________________
> Yahoo! Mail - PC Magazine Editors' Choice 2005
> http://mail.yahoo.com
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>