[mythtv-users] Lost a disk - How to remove missing shows from database?

[Michael Watson]

On 23/01/2012 8:11 AM, Tom Hayward wrote:
> On Sun, Jan 22, 2012 at 09:54, Matt Emmott<memmott at gmail.com>  wrote:
>> One of the disks in my storage group went bye-bye, and now there are hundreds of orphaned listings in my slave BE. I've tried removing the files using MythWeb, but Mythweb for me has always been historically slow, and attempting to select and delete more than one showing at a time results in a timeout. I was wondering if there's a SQL query I could run to delete all shows whose file size is less than 1 byte or something. I've already run a backup of the database.
> Try this script:
> http://www.mythtv.org/wiki/Find_orphans.py
>
> I've only used it to remove orphaned files, but it also supports
> finding and removing orphaned db entries.
>
>
> Tom
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
>

Yes, the find_orphans.py script works really well, can also removes 
thumbnail images, orphaned DB entries, orphaned files, and unknown files 
located in your storage folders.

Michael