[mythtv-users] hard disk died ... how to delete all recordings from the db? (which mysql tables to trunctate)

[Ma Begaj]

2008/3/26, Ma Begaj <derliebegott at gmail.com>:
> 2008/3/10, Michael T. Dean <mtdean at thirdcontact.com>:
>
> > On 03/10/2008 10:58 AM, David George wrote:
>  >  > On 03/10/2008 09:42 AM, Ma Begaj wrote:
>  >  >
>  >
>  > >> my hard disk died yesterday while watching "two and a half men" :). I
>  >  >> just heard a few "click" sounds from the hdd in the mythbox and
>  >  >> mythfrontend stopped responding a few seconds later. instead of trying
>  >  >> to save data with "dd" or something else over ssh, I rebooted ...
>  >  >> xfs_repair cannot do anything (cannot find superblock, and it quits
>  >  >> with some "fatal error") .. If you have some kind of advice for me ...
>  >  >> I accept everything :)
>  >  >>
>  >  >> it was Samsung 500GB, 4-5 months old ... so be careful when you get
>  >  >> your new hdd :)
>  >  >>
>  >  >> I am getting a new hdd today/tommorow and I would like to delete all
>  >  >> recordings from the database which was on another hdd. And I don't
>  >  >> want to delete them with my remote or from mythweb because there a
>  >  >> 200-300 hundred recordings in the database.
>  >  >>
>  >  >> which mysql do I have to truncate to delete all recordings? I do NOT
>  >  >> want to delete my recording rules.
>  >  > You may be interested in this message which is similar to what you are
>  >  > asking:
>  >  > http://www.gossamer-threads.com/lists/mythtv/users/316769#316769
>  >  >
>  >  > I had the same thing happen here and used myth.find_orphans.pl in the
>  >  > contrib directory.  However it didn't allow me to set the programs to
>  >  > re-record in case they come on again so I added a rerecord option to
>  >  > it.  Here is a link to the patch:
>  >  >
>  >  > http://svn.mythtv.org/trac/ticket/4677
>  >  >
>  >  > This has actually been added to the latest trunk (after the .21 release
>  >  > so it is not in .21).
>  >
>  >
>  > Please, no.***  If using 0.21, you should go into mythfrontend's
>  >  Watch/Delete Recordings screen.  Then, go to the "All Programs" category
>  >  name (left column), and use Menu to "Add this Group to Playlist."  Then,
>  >  use Menu to select "Playlist Options", then select "Delete" or "Delete,
>  >  and allow re-record."
>  >
>  >  Note that you can do the same thing for 0.20; however, you won't be
>  >  given the "Delete, and allow re-record" option.
>  >
>  >  Mike
>
>
>
> Sorry for responding so late, but I did not have time to clean the
>  recordings until today. I liked your idea, but it did not work.
>
>  I was in "Delete Recordings" and selected all shows from "All
>  Programs" added the group to the playlist and all recordings were
>  selected. I pressed "Delete and allow re-record" and after 2-3 seconds
>  all recordings were not selected but still there.
>
>  I restarted both, backend and frontend, but without success. I tried
>  selecting just a few recordings from a smaller group (three
>  recordings) and it still does not work.
>
>  I did not want to test the above mentioned perl script before I
>  understand why your solution is not working.
>
>  Here are the logs (frontend and backend) written while trying your
>  solution. I am copy/pasting the logs here because I am not sure
>  whether attachments are allowed on the list.
>
>  I am using 0.21 + fixes.
>
>  Thanks a lot.

is this a bug? or is something in my configuration wrong?