[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