[mythtv-users] After disk crash (not OS disk), which tables to clear in mysql?

Nick Morrott knowledgejunkie at gmail.com
Sun Aug 12 21:59:59 UTC 2007


On 12/08/07, Edgar Matzinger <edgar at edgar-matzinger.nl> wrote:
> Hello list,
>
>   this is probably a FAQ (not found on the FAQ....), but after a disk
> disk crash, where I lost all my recordings, how do I tell mythtv that
> they are gone?
>
>   In the current sutuation, I've an empty disk to hold my recordings.
> But the database still has knowledge about the old recordings....
> Question is: Which tables do I have to empty? All tables that have
> the word 'record' in it? Or only a subset like 'record', 'recorded',
> 'recordedprogram' and 'oldrecorded'?

The myth.find_orphans.pl script from mythtv/contrib
(http://cvs.mythtv.org/trac/browser/trunk/mythtv/contrib is running
trunk) will sort this out without you having to manually edit the
database.

-- 
Nick

MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin


More information about the mythtv-users mailing list