[mythtv-users] update recordings database?
leo.butler at member.fsf.org
leo.butler at member.fsf.org
Tue Apr 30 16:15:13 UTC 2013
>From mailnull Tue Apr 30 02:04:47 2013
X-Spam-Status: No, score=-6.6 required=5.0 tests=BAYES_00,RCVD_IN_DNSWL_MED,
RP_MATCHES_RCVD autolearn=ham version=3.3.2
Date: Mon, 29 Apr 2013 22:03:23 -0400
From: "Michael T. Dean" <mtdean at thirdcontact.com>
Reply-To: Discussion about MythTV <mythtv-users at mythtv.org>
Content-Type: text/plain; charset="us-ascii"; format=flowed
On 04/29/2013 09:40 PM, Nick Rout wrote:
> On Tue, Apr 30, 2013 at 1:32 PM, wrote:
>
>> Hi, I was experimenting recently and in the process of rolling-back
>> some changes, I overwrote my myth recordings database. The result is
>> that I have 10 days of recordings on the hdd that the backend has no
>> information on.
>>
>> Question: how can I add the information on these recordings back to
>> the database?
>>
>
> Go to one of the backups made druing the 10 day period?
>
>
And if you didn't do any backups during those 10 days, the only
supported solution is to put those recordings into the Video Library.
Video Library is the location for user-managed video (i.e. video where
the user provides file name, directory/storage organization) as well as
user-provided video (i.e. not-recorded by "this" MythTV
instance--meaning not already in the Watch Recordings section).
If you don't like the idea of some parts of the series being in Watch
Recordings and some parts in Video Library, you have 2 options: 1) let
MythTV re-record the episodes when/if they re-air or 2) move all the
rest of the episodes of that series to Video Library. Note that moving
recordings to Video Library has huge benefits, including better support
for large collections of video (Watch Recordings become very cumbersome
when you have a lot of recordings), better
navigability/sorting/filtering (without having to go back and forth
between Watch Recordings and frontend settings to change it), the
ability to use meaningful file names (that allow you to identify the
content even if you lose the MythTV database), ability to organize the
videos how you like (using directories to provide hierarchical
organization), excellent metadata support, and more. IMHO, anyone who
keeps recordings--rather than watching and immediately deleting the
recording--should seriously consider moving those recordings to Video
Library.
http://www.gossamer-threads.com/lists/mythtv/users/519758#519758
Note that you can use mythvidexport.py to help you move the recordings.
http://www.mythtv.org/wiki/Mythvidexport.py
There are a couple of versions that have some updates for 0.26 out
there, and I expect the wiki version will get an update before long (now
that mythtranscode's lossless cutting is working, again, the author has
started using mythvidexport.py, again, to archive some shows).
Mike
Mike, thanks for the note. I do use the video library. If I am to
understand your message, there is no way to migrate recordings to the
library from a frontend, correct?
I have poked around in the mysql shell, I can find the missing
recordings in the recordmatch column and I can find matching recorded
files. I need to figure out how/what to update in the database. That
shouldn't be too difficult, I hope.
Any pointers/tips would be appreciated.
Leo
More information about the mythtv-users
mailing list