[mythtv-users] How do I empty a channel's listings?

Ian Forde ian at duckland.org
Sat Jan 20 05:16:34 UTC 2007

On Fri, 2007-01-19 at 21:13 -0800, Brad DerManouelian wrote:
> On Jan 19, 2007, at 9:09 PM, Ian Forde wrote:
> > After running mythfilldatabase last night, my HD NBC affiliate  
> > (known as
> > 11-1) has the listings for FOX.  At least it did when I went to sleep
> > last night.  Today it had some NBC listings, but farther out it still
> > had the Fox listings.
> >
> > I just ran mythfilldatabase again, and it pushed the Fox listings out
> > farther (another day).  So I'm wondering how to empty the listings for
> > that channel so that I can run a mythfilldatabase to refill it.
> >
> > I'm sure there's a rather unusual SQL statement that can do this, BTW,
> > but any way that'll work is fine by me...
> >
> > Thanks,
> > 	-Ian
> It might be easier just to do a mythfilldatabase --refresh-all in  
> case there are any other crazy listings you didn't happen to notice.

True - I just used phpMyAdmin and figured out that I wanted a:

DELETE FROM `program` WHERE `chanid` = 5160;

so now mythfilldatabase is running... if I don't get the desired
results, I'll try the refresh-all...


                       Ian Forde
                       RHCE (7,EL4), CCSE, SCNA, SCDME

More information about the mythtv-users mailing list