View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 4 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
 Post subject: Delete Multiple Shows
PostPosted: Sun Feb 14, 2010 8:16 pm 
Offline
Joined: Fri Jul 21, 2006 9:29 pm
Posts: 19
I am running R6 and things went very bad last week. On reboot, the drive had many errors and upon fixing those I had lost all of my saved shows. I got the machine working but it recorded ~2,500 0 byte shows in one day. A reboot has seemed to fix that but I am at a loss on how to get rid of all of these shows from the database. Can anyone help me get rid of these faster than deleting them one at a time?


Top
 Profile  
 
 Post subject:
PostPosted: Mon Feb 15, 2010 9:09 am 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
Search for "myth.find_orphans.pl" which is designed for cleaning up situations like this.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Feb 15, 2010 4:22 pm 
Offline
Joined: Fri Jul 21, 2006 9:29 pm
Posts: 19
Perfect. I found it in /usr/share/mythtv/contrib/ and it deleted all 2580 recordings in a few seconds.

Thank you for the help. You have saved me.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Feb 17, 2010 11:45 am 
Offline
Joined: Sun Jul 24, 2005 4:16 pm
Posts: 508
Location: Ft. Worth TX
I ran this on KM 5.5. and it helped clean up around a hundred orphans caused by a DB crash & rebuild.

However an exploratory run on my LH 6.07 machine returns this:

Code:
[root@mythbox101 contrib]# /usr/share/mythtv/contrib/myth.find_orphans.pl
DBI connect('database=mythconverg:host=mythbox101','mythtv',...) failed: Can't connect to MySQL server on 'mythbox101' (111) at /usr/share/mythtv/contrib/myth.find_orphans.pl line 99
Cannot connect to database mythconverg on host mythbox101:


Any hints on actions to try ?
(The machine is working normally, with no database issues that I know of....)


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 23 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu