Removing unwanted channels

Myth Howto:

"""
23.9 Removing unwanted channels

If mythfilldatabase grabbed a channel which you do not want to include in your TV listings, you can remove the entries from the grabber configuration and the MySQL database. This often happens with premium channels; for example, HBO or Showtime may be available on your cable TV system, but is scrambled because you're not a subscriber to that channel. Since you can never watch it, you want to get rid of it.

If you are using the DataDirect service, login to your account at http://labs.zap2it.com/ to modify your lineup. Uncheck the boxes for any unwanted channels, and they will no longer be included in your download.

If you are using a grabber from XMLTV, comment out the channel from the ~/.mythtv/.xmltv file by inserting the word "not " (including the space) in front of the unwanted entry. This will prevent xmltv from grabbing future listings.

Next, delete the unwanted item from the channel table so that it will not appear in the EPG or when changing channels. To delete the data from the database we need to perform some steps. First, assuming that HBO is channel 15, we need to find out the internal chanid used by MySQL:

$ mysql -u root mythconverg
mysql> select chanid from channel where channum=15;
+--------+
| chanid |
+--------+
| 1015 |
+--------+
1 row in set (0.00 sec)
mysql> delete from channel where chanid = 1015;


Old program data will be removed over the course of a week. However, you may want to immediately delete any current program listings for the channel that has been removed:

$ mysql -u root mythconverg
mysql> delete from program where chanid = 1015;
"""