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
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
