[mythtv-users] Storage of currently tuned channel

[mythtv at sci.fi]

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 <drayson at net1plus.com> wrote:
> 
> > > -----Original Message-----
> > > From: mythtv-users-bounces at mythtv.org
> > [mailto:mythtv-users-
> > > bounces at mythtv.org] 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
> > mythtv-users at mythtv.org
> >
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> > 
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users