[mythtv-users] mythfilldatabase: how to delete Program Guide

[Abhi]

Worked like a charm
thanks

However, the other problem remains:

Watching TV--> Menu-->Program Guide
By the time Program Guide appears, it takes ~ 5 seconds! (even though now 
the guide has only about 60 odd channels)
Any Ideas?

- Abhi


--On Tuesday, September 14, 2004 4:08 PM -0700 Bruce Markey <bjm at lvcm.com> 
wrote:

> Abhi wrote:
>> Hi,
>>    I accidentally downloaded all channels (from labs.zap2it.com) from
>> the lineup using mythfilldatabase. So now the guide contains all these
>> (~500) channels.
> ...
>>    Is there a way to prune the guide? Can I delete some tables from the
>> mysql to delete the guide and then re-run mythfilldatabase?
>
> $ mysql -u mythtv -pmythtv mythconverg
> mysql> delete from channel;
> mysql> delete from program;
> mysql> quit
> $ mythfilldatabase
>
> --  bjm
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users