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

[Edgar Matzinger]

Hi Nick,

On 08/12/2007 11:59:59 PM, Nick Morrott wrote:
> 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.

  this would be a nice solution,but is - alas - not available for 0.20....
Ah well, I will examine the contents of the perl script and run it by
hand.

Thanks anyway, cu l8r, Edgar.
-- 
       \|||/
       (o o)                                             Just curious...
----ooO-(_)-Ooo---------------------------------------------------------