[mythtv-users] modifying recorded program descriptions

Kevin Kuphal kuphal at dls.net
Mon Dec 13 00:33:28 UTC 2004


mielikki-ivtv wrote:

> If I want to change the title, subtitle, or description of a recorded 
> show using MySQL commands, are there any caveats I should be aware of?
>
> The basic command I would use is something like this (I haven't syntax 
> checked this, so just use it to get the idea):
>
> UPDATE recorded SET starttime=starttime, endtime=endtime, title='new 
> title' WHERE chanid=@ChanId AND starttime=@StartTime;
>
> I'm assuming that, since the starttime and endtime are of type 
> TIMESTAMP, it is a good idea to make sure they don't get reset 
> (probably only need to specify it for the first TIMESTAMP in the 
> table, but doesn't hurt to do both).
>
> Any other tables that might be affected?
>
> One caveat might be that I might mess up the stuff that tries to 
> determine if I have already recorded this episode of a series.

I'd suggest installing phpmyadmin and using that to edit the DB.  You 
can use it to edit the specific fields you want without fear of breaking 
things in general.

Kevin



More information about the mythtv-users mailing list