[mythtv-users] Mass channel deletes

[Bruce Markey]

Dave Sherohman wrote:
> Since I didn't recognize all the abbreviated channel IDs, I just set
> myself up initially for all channels that I receive when I signed up
> with zap2it.  I've now gone through and identified about two dozen
> channels that don't interest me and have removed them from my zap2it
> lineup.
> 
> Section 22.9 of the howto states that I now should go into the
> database directly and run a couple SQL statements to get rid of "the"
> channel I deleted... but that seems a bit labor-intensive when you're
> doing more than a couple channels all at once.  Is there a quicker
> way to do a bulk channel removal?  Would I break my existing
> recordings or upcoming recording schedule if I just deleted all
> records from the channel table, then ran mythfilldatabase manually to
> reconstruct it?

That would work but would leave behind program information that
might be found in searches so you may want to remove all the
program information also.

$ mysql -u mythtv -pmythtv mythconverg
mysql> truncate table channel;
mysql> truncate table program;
mysql> truncate table programrating;
mysql> truncate table programgenres;
mysql> truncate table credits;
mysql> truncate table people;

then run "mythfilldatabase" again.

--  bjm