[mythtv-users] Removing Unwanted Channels

[Joe Votour]

http://www.mythtv.org/docs/mythtv-HOWTO-22.html#ss22.9

-- Joe

--- Greg Grotsky <spikeygg at gmail.com> wrote:
> I don't know if it's correct but this is how I get
> rid of channels I don't want:
> 
> mysql> delete from channel where callsign='MTV';
> 
> That line will get rid of your MTV channel (assuming
> you want to get
> rid of MTV).
> Anyone care to agree or disagree?  I hope it's the
> right way cause
> I've been using it and it seems to work but I'm
> afraid I'm leaving
> open hooks in my sql database.
> 
> -Greg
> 
> On 4/24/05, Larry K <lunchtimelarry at gmail.com>
> wrote:
> > When I first set up my zap2It channel list, I put
> in several channels that I
> > have since removed.  Problem is, these unwanted
> channels are still populated
> > in my mythtv database, so they clutter up the EPG
> and the mythweb listings. 
> >  
> >  Is there an elegant way of purging these unwanted
> channels?  I assume the
> > channels could be deleted form the mysql database,
> but I thought I'd ask if
> > there is a better way before I go messing with the
> database.  Using the
> > following query, I think I have identified the
> rows I want to delete.  Not
> > sure if there are any referential constraints to
> complicate the delete of
> > rows from channel.  Thoughts?
> >  
> >  mysql> select chanid,callsign from channel;
> >  +--------+----------+
> >  | chanid | callsign |
> >  +--------+----------+
> >  |   1004 | WRC      |
> >  |   1005 | WTTG     |
> >  |   1006 | WPXW    |
> >  
> >  <snip>
> >  
> >  |   1068 | MTV      |
> >  |   1069 | VH1      |
> >  +--------+----------+
> >  45 rows in set (0.00 sec)
> >  
> >  
> >  
> >  
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> >
>
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> > 
> > 
> >
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
>
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> 

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com