[mythtv-users] Cleaning up orphan database records

Michael T. Dean mtdean at thirdcontact.com
Thu Apr 19 17:21:37 UTC 2007


On 04/19/2007 12:36 PM, Bob Sully wrote:
> I have about 35 records in the database pointing to old LiveTV recordings
> that no longer exist on disk.  I don't know how this happened, but I'd
> like to clean them up.  Trying to delete them through MythWeb is
> ineffective - this shows up in the backend logs, and the entry doesn't get
> deleted from the database:
>
>
> File /mythtv/recordings/3214_20070213220901.nuv does not exist for chanid
> 3214 at Tue Feb 13 22:09:01 2007 when trying to delete recording.
>
>
> Are there any utilities within Myth which will clean up the DB, or do I
> have to figure out how to do it using MySQL commands?

Delete them from mythfrontend.  It will allow you to delete the 
recording information, anyway, after asking you to confirm.

Mike


More information about the mythtv-users mailing list