[mythtv-users] Removing Unwanted Channels

[Larry K]

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)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20050424/9c894e00/attachment.htm