[mythtv-users] reconciling database and recorded files

[Brad DerManouelian]

On Sep 3, 2008, at 7:50 PM, Jerome Yuzyk wrote:

>
> I finally got my new big drive formatted* and have begun  
> amalgamating my
> recordings onto it. I notice though, that I have several files for 2- 
> hour
> recordings that I don't have listed in my database, at least as seen  
> through
> MythWeb.
>
> MythWeb does list these files, but after recording them I had edited  
> out
> everything I didn't want, leaving these recordings at about 10  
> minutes. I've
> just always assumed MythWeb and/or the database doesn't list the  
> actual
> length after editing and transcoding. Could these 2-hour recordings  
> be left
> over from what I did?
>
> 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?

http://www.mythtv.org/wiki/index.php/Myth.rebuilddatabase.pl
http://www.mythtv.org/wiki/index.php/Myth.find_orphans.pl