[mythtv-users] Removing channel from the database

[Martina Walter]

On Mon, 2004-01-05 at 09:38, S Rollins - Software and Security Issues
wrote:
> How do I remove a channel from the database?
> 
> I have one channel that got messed up, because zap2it changed what they
> called the channel.
> 
> So, now I have two listings in the guide for channel 2: "CICA" and "TVO".
> CICA has listings, TVO has nothing.  How do I remove the old "TVO" so it
> doesn't take up space on my program guide?  I presume I need to edit the
> database, but I'm not sure exactly what do delete and/or edit.

mysql -u root mythconverg

mysql> select * from channel where name="TVO;
mysql> delete from channel where name="TVO";

If the first line gives you an empty set, try callsign="TVO" instead (in
my database they are different).

HTH

Martina