[mythtv-users] Removing Unwanted Channels

[Greg Grotsky]

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
> 
> 
>