[mythtv-users] Some lost recording due to Seagate 500GB crash

[Michael Rice]

On 2/15/08, Chuck Peters <cp at ccil.org> wrote:
> I have lost some recordings and would like to selectively delete the
> database entries and files.
>
> rm `ls -l /home/mythtv/store| grep /500/media/recordings/|awk '{print
> $8}'`* will get the files.
>
> Is there some command or script out there that I could do something like:
> rmdatabaseentry `ls -l /home/mythtv/store| grep
> /500/media/recordings/|awk '{print $8}'

There is a script in the contrib directory: myth.find_orphans.pl
that might do what you want without having to mess with
mysql commands directly.

(Standard Disclaimer: backup your database before doing anything)