[mythtv-users] How to rename a (mis)recorded program?

[Dan Morphis]

Dudley Atkinson wrote:

> > Dan Morphis wrote:
> >
> >> Chris Pinkham wrote:
> >>
> >>>> So Sky decided to change things at the last minute and
> >>>> switched a couple of programs round: 24 and Cold Case. It
> >>>> ended up that 24 was played in Cold Case's slot so we only
> >>>> missed one :) But now it's mis-labelled :(
> >>>>
> >>>> How do I fix that?
> >>>>
> >>>> Happy to dig into the DB tables but not sure which ones to
> >>>> edit. Also not sure what side effects may ensue?
> >>>>
> >>>> David
> >>>
> >>>
> >>> update recorded set starttime = starttime, title = "new title",
> >>> subtitle = "new subtile", description = "new description"
> >>> where chanid = 1010 and starttime = 20040601203000;
> >>
> >>
> >> David, the starttime = startime part of the SQL is very
> >> important, if you don't do that, you'll end up with a messed up
> >> recorded table. I speak from experience on that one :-)
> >>
> >> -dan
> >
> > Thank you both :)
> >
> > Ah, dan - that would explain why it's gone wrong before when I've
> > used mysqlcc to make a change (which is one reason I asked this
> > time). How do you fix it if you don't use starttime=starttime? and,
> > out of the incessant need to learn, what does that do? integrity of
> > some sort?
> >
>
>  You might consider getting phpmyadmin; then you can make database
>  edits from a web browser.
Yeah, but if you don't do the sql directly, you will screw up the 
recorded table in the db.  I speak from experience.