[mythtv-users] How do I empty a channel's listings?
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...
RHCE (7,EL4), CCSE, SCNA, SCDME
More information about the mythtv-users