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

Matt Emmott memmott at gmail.com
Sun Jan 22 16:54:02 UTC 2012


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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.mythtv.org/pipermail/mythtv-users/attachments/20120122/94b1c40f/attachment.html 


More information about the mythtv-users mailing list