[mythtv-users] WAF through the floor, with lost database!

Michael T. Dean mtdean at thirdcontact.com
Tue Dec 31 20:15:26 UTC 2013


On 12/31/2013 02:36 PM, Paul Gardiner wrote:
> On 31/12/2013 18:04, Michael T. Dean wrote:
>> On 12/31/2013 08:06 AM, Paul Gardiner wrote:
>>> Useful advice. I'll look into mythlink for the future. Also the idea of
>>> using mythvideo so as to regenerate the metadata is interestingm but I
>>> doubt if I can realistically regenerate the title and subtitle or
>>> episode numbers to give something for mythvideo to go on.
>>
>> Well, you can always just dump them into Video Library with the naming
>> scheme you mentioned and then as you identify them (even if as you're
>> watching them), edit the metadata to give them a proper title and/or
>> subtitle.
>>
>> And, since Video Library can easily rescan items, you can identify a
>> series name for a show, then use file system tools to rename the group
>> of them (like rename--either the Perl or the util-linux-ng one--or
>> whatever) and move them into an appropriate directory structure so that
>> it can identify the series and re-title it for you.  I'd think that
>> would be much easier than using Watch Recording's Edit Metadata on each
>> recording, individually.  The only challenge will be getting rid of the
>> videos (with the bad titles, etc) before you rescan--generally, I'd just
>> move the videos outside the Videos Storage Group directories, then
>> rescan, then move it back to the proper series directory structure under
>> Videos.
>
> Yeah, hmmm, I do see what you are saying... wouldn't be able to cut
> and transcode from there though.

I know Jim Stichnoth was working on allowing that.  I don't know if it's 
in 0.27 or not, though.

>
>>> Given that,
>>> whare I'd like to do is put them back in recorded, so is there any
>>> harm to generating a load of new entries in recorded, and running a
>>> load of mythcommflag --rebuild jobs to restore the seek tables?
>>
>> No more harm than writing a Word document in a hex editor.  It works
>> great--provided you do everything exactly right.  And, of course, even
>> if it looks OK, it may have problems that don't surface until long in
>> the future.
>>
>> The main reason this is discouraged is because there's a lot of stuff
>> that needs to be done exactly right--more, now, than a few years ago.
>> And, if it's not all done right, you'll have issues (with everything
>> from playback to recording/scheduling to even data loading/transfer). We
>> haven't designed Watch Recordings to be resilient to broken data. It's
>> designed only as a place to (temporarily) display new recordings, and
>> Video Library is the part designed to allow user management,
>> organization, naming and importing of videos.
>
> Temporarily? So I haven't even identified the correct table from the
> sound of things. :-) Is there another table to which new recording move
> then?

Well, it's a bunch of tables that need updating.  I seriously don't even 
know all the things that have to be updated, myself.

Mike


More information about the mythtv-users mailing list