[mythtv-users] Deleting channels from listings and error 1045 from mysql

and hons at rcn.com
Tue Sep 9 02:54:29 EDT 2003


Uuups!
but thanks for the feedback
rgds
anders

On Monday, September 8, 2003, at 11:43 PM, Jarod C. Wilson wrote:

> On Monday, Sep 8, 2003, at 22:36 US/Pacific, and wrote:
>
>> Jarod,
>> I jumped the gun and realized as I cliked the send button why it 
>> might not have worked for me:
>> I forgot to specify use and password... ;-)
>
> Bingo.
>
>> So when I did: "mysql -u root -p mythconverg", everything worked fine.
>> sorry about that
>
> Not a problem, though I think you were addressing the wrong person. 
> Jarod กม JAC. Jarod = Jarod C. Wilson = JCW and JAC = Joseph A. Caputo. 
> :)
>
> JAC wrote
>>>>> Try the following:
>>>>>
>>>>> 	% mysql mythconverg
>>>>> 	mysql> select chanid, channum, name from channel;
>>>>>
>>>>> This will list all the channels in your database.  Note the 
>>>>> 'chanid' value
>>>>> for the channel(s) you want to remove.  Suppose the chanid is 
>>>>> '1050' (FYI,
>>>>> that's channel 50 on video source 1).  You would then do:
>>>>>
>>>>> 	mysql> delete from channel where chanid = 1050 ;
>>>>>
>>>>> Now the channel won't show up in your EPG, and since you commented 
>>>>> it out of
>>>>> your XMLTV file, it won't get re-added next time you run 
>>>>> mythfilldatabase.
>>>>>
>>>>> Good luck!
>>>>>
>>>>> -JAC
>
> --Jarod
>
> -- 
> Jarod C. Wilson, RHCE
>
> Got a question? Read this first...
> http://catb.org/~esr/faqs/smart-questions.html
>
> MythTV, Red Hat Linux 9 & ATrpms documentation:
> http://pvrhw.goldfish.org/tiki-page.php?pageName=rh9pvr250
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users




More information about the mythtv-users mailing list