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

[Jarod C. Wilson]

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