Re: [mythtv-users] Removing Unwanted Channels
Excellent! That utility in Mythweb does the trick. I figured there must be a more elegant way to do this than manually deleting rows fro the database.On 4/25/05, Big Wave Dave [EMAIL PROTECTED] wrote: On 4/24/05, Greg Grotsky [EMAIL PROTECTED] wrote: On 4/24/05, Joe Votour [EMAIL PROTECTED] wrote: http://www.mythtv.org/docs/mythtv-HOWTO-22.html#ss22.9 -- Joe Ah, yes, the beloved HowTos... I should have known.Thanks Joe!Any reason a person shouldn't use the utility in MythWeb? Dave--My MythTV Box:http://www.dynamicis.com/~superdave/mythtv/-- Are Your Friends Lemmings?-- http://www.lemmingshirts.com___mythtv-users mailing list mythtv-users@mythtv.orghttp://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
[mythtv-users] Removing Unwanted Channels
When I first set up my zap2It channel list, I put in several channels that I have since removed. Problem is, these unwanted channels are still populated in my mythtv database, so they clutter up the EPG and the mythweb listings. Is there an elegant way of purging these unwanted channels? I assume the channels could be deleted form the mysql database, but I thought I'd ask if there is a better way before I go messing with the database. Using the following query, I think I have identified the rows I want to delete. Not sure if there are any referential constraints to complicate the delete of rows from channel. Thoughts? mysql select chanid,callsign from channel; ++--+ | chanid | callsign | ++--+ | 1004 | WRC | | 1005 | WTTG | | 1006 | WPXW | snip | 1068 | MTV | | 1069 | VH1 | ++--+ 45 rows in set (0.00 sec) ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Removing Unwanted Channels
I don't know if it's correct but this is how I get rid of channels I don't want: mysql delete from channel where callsign='MTV'; That line will get rid of your MTV channel (assuming you want to get rid of MTV). Anyone care to agree or disagree? I hope it's the right way cause I've been using it and it seems to work but I'm afraid I'm leaving open hooks in my sql database. -Greg On 4/24/05, Larry K [EMAIL PROTECTED] wrote: When I first set up my zap2It channel list, I put in several channels that I have since removed. Problem is, these unwanted channels are still populated in my mythtv database, so they clutter up the EPG and the mythweb listings. Is there an elegant way of purging these unwanted channels? I assume the channels could be deleted form the mysql database, but I thought I'd ask if there is a better way before I go messing with the database. Using the following query, I think I have identified the rows I want to delete. Not sure if there are any referential constraints to complicate the delete of rows from channel. Thoughts? mysql select chanid,callsign from channel; ++--+ | chanid | callsign | ++--+ | 1004 | WRC | | 1005 | WTTG | | 1006 | WPXW| snip | 1068 | MTV | | 1069 | VH1 | ++--+ 45 rows in set (0.00 sec) ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Removing Unwanted Channels
http://www.mythtv.org/docs/mythtv-HOWTO-22.html#ss22.9 -- Joe --- Greg Grotsky [EMAIL PROTECTED] wrote: I don't know if it's correct but this is how I get rid of channels I don't want: mysql delete from channel where callsign='MTV'; That line will get rid of your MTV channel (assuming you want to get rid of MTV). Anyone care to agree or disagree? I hope it's the right way cause I've been using it and it seems to work but I'm afraid I'm leaving open hooks in my sql database. -Greg On 4/24/05, Larry K [EMAIL PROTECTED] wrote: When I first set up my zap2It channel list, I put in several channels that I have since removed. Problem is, these unwanted channels are still populated in my mythtv database, so they clutter up the EPG and the mythweb listings. Is there an elegant way of purging these unwanted channels? I assume the channels could be deleted form the mysql database, but I thought I'd ask if there is a better way before I go messing with the database. Using the following query, I think I have identified the rows I want to delete. Not sure if there are any referential constraints to complicate the delete of rows from channel. Thoughts? mysql select chanid,callsign from channel; ++--+ | chanid | callsign | ++--+ | 1004 | WRC | | 1005 | WTTG | | 1006 | WPXW| snip | 1068 | MTV | | 1069 | VH1 | ++--+ 45 rows in set (0.00 sec) ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Removing Unwanted Channels
On 4/24/05, Joe Votour [EMAIL PROTECTED] wrote: http://www.mythtv.org/docs/mythtv-HOWTO-22.html#ss22.9 -- Joe Ah, yes, the beloved HowTos... I should have known. Thanks Joe! -Greg ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Removing Unwanted Channels
On 4/24/05, Greg Grotsky [EMAIL PROTECTED] wrote: On 4/24/05, Joe Votour [EMAIL PROTECTED] wrote: http://www.mythtv.org/docs/mythtv-HOWTO-22.html#ss22.9 -- Joe Ah, yes, the beloved HowTos... I should have known. Thanks Joe! Any reason a person shouldn't use the utility in MythWeb? Dave -- My MythTV Box: http://www.dynamicis.com/~superdave/mythtv/ -- Are Your Friends Lemmings? -- http://www.lemmingshirts.com ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
