[mythtv-users] reconciling database and recorded files

Michael T. Dean mtdean at thirdcontact.com
Thu Sep 4 17:49:57 UTC 2008

On 09/04/2008 05:59 AM, Jerome Yuzyk wrote:
> On Wednesday 03 September 2008 20:50, Jerome Yuzyk wrote:
>> Then this got me wondering about the subject of this message. Is there any
>> tool that would reconcile database entries vs recorded files (probably
>> including the PNG thumbnails)? Maybe someone has a handy SQL query snippet
>> or pointer to such to get me started?
> Before anyone takes the time to reply,

heh.  http://www.gossamer-threads.com/lists/mythtv/users/348043#348043

>  I have answered my own question, and 
> wrote a Perl script to give me a little report on all the 'recorded' records 
> in the db, files with no record, records with no file, and thumbnails with no 
> record. It's not fancy, but it answered part of my question.

So, basically, instead of reading Brad's response, you were busy 
rewriting the functionality provided by the two scripts to which he 
referred you.  ;)

If you're still really motivated, perhaps you could re-re-do those 
scripts.  Both myth.rebuilddatabase.pl and myth.find_orphans.pl are old, 
semi-maintained hacks that need to be ported to use the MythTV perl 
bindings.  Your rewriting them to use the bindings and cleaning them up 
(and, IMHO, combining them into a single script) would be very useful to 
the project.  And, since you seem to know Perl... :)

If you are interested and you have questions, I'd be happy to provide 
some pointers/recommendations.


More information about the mythtv-users mailing list