[mythtv-users] Cleaning up the channels DB

[David Whyte]

In my upgrade to 0.17 I really screwed things up!  In the end I delted
the channels and set them up again, but not in the exact same way.

Now, I am trying to add ABC2 (a new aussie channel) but it is picking
up the data for a channel which I cannot tune (SBS) and so generally
hide.

The following are the relevant excerpts from the program and channel tables...

mysql> select distinct chanid from program;
+--------+
| chanid |
+--------+
|   1000 |
|   1001 |
|   1002 |
|   1008 |
|   1020 |
|   1021 |
|   1024 |
|   1025 |
|   1026 |
|   1027 |
|   1028 |
+--------+
11 rows in set (0.02 sec)
 
mysql> select distinct chanid, channum, callsign from channel;
+--------+---------+-----------------+
| chanid | channum | callsign        |
+--------+---------+-----------------+
|   1001 | 2       | ABC TV Brisbane |
|   1008 | 10      | TEN Digital     |
|   1021 | 7       | 7 Digital       |
|   1000 |         | 1000            |
|   1020 | 9       | Nine Digital    |
|   1028 | 21      | ABC2            |
+--------+---------+-----------------+
6 rows in set (0.00 sec)
 
mysql>

Can I simply remove from the program table the data for the chanids
that don't exist in the channel table?  My goal is to clear up the
ABC2/SBS mixup!

Cheers,
Dave
-- 
GMAIL is 'da bomb baby....YEAH

I have GMail invites, if you want one, email me direct.