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

Tom Hayward esarfl at gmail.com
Sun Jan 22 21:11:17 UTC 2012


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


More information about the mythtv-users mailing list