The MySQL line is as follows, I think:
mysql -uUSER -Ddatabase -pPASSWORD -e"UPDATE cardinputl SET
startchan='the_starting_channel_you_want' where
cardinputid='the_id_of_the_card_you_want_to_change';"
Now just replace the following stuff:
-uUSER --> replace the USER with a valid username for MySQL (root is one)
-pPASSWORD --> the password of the above user
the_starting_channel_you_want --> as was already said, change into the
channel you want
the_id_of_the_card_you_want_to_change--> this is the id of the card you
want to affect
That should do it, although I'm not sure this is what you wanted ;-)
Is there a way to do this from within a script like
Jarod's mythpowerbutton.sh?
I am trying to make this as wife/children friendly and
run into this problem. Would like to allow them to hit
a button and have the box kill the frontend, stop the
backend, fix the start channel, start the backend, and
start the front end. I can do all except the fixing
the start channel.
Anyone have a one line command prompt way to do this?
Thanks,
Rob
--- Marc Tousignant <[EMAIL PROTECTED]> wrote:
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> [mailto:mythtv-users-
> > [EMAIL PROTECTED] On Behalf Of Brett May
> > Sent: Monday, August 08, 2005 4:10 AM
> > To: Discussion about mythtv
> > Subject: [mythtv-users] Storage of currently tuned
> channel
> >
> > Hi All,
> >
> > Can anyone tell me where the current tuned channel
> is stored in mythtv.
> > Is it stored in the database anywhere?
> >
> > There seems to be a bug in mythtv 18.0 that allows
> you to change to non
> > visible
> > channels (probably fixed in cvs). I have managed
> to change to a HD
> > channel
> > and ViaXVMC can't handle it and crashes the
> frontend. Unfortunately I am
> > now stuck on this channel and can't find a way to
> change to a valid
> > channel
> > before starting mythbackend. I can use tzap piped
> to mplayer to watch
> > other
> > channels so its not the card that is stuck.
> Mythbacked is changing to
> > this channel
> > on startup.
> >
> > Any help would be greatly appreciated.
> >
> > Cheers,
> > Brett
> >
>
> Simplest way to do this I think is this.
> First stop the backend. Not sure if editing the
> database while it is running
> will work right.
>
> Login to mysql
> mysql -umythtv -p mythconverg
> If you left it default the password is mythtv too.
> Otherwise use your own
> user/pass.
>
> select cardinputid, inputname, startchan from
> cardinput;
> This will tell you which card is your HD card and
> the current channel.
>
> UPDATE cardinput SET startchan='13' WHERE
> cardinputid='1';
> This will change the channel in the database.
> Replace 1 with the cardinput
> from next to your hd tuner and replace the 13 with
> any valid hd channel.
>
>
> > _______________________________________________
> mythtv-users mailing list
> [email protected]
>
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
