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 [EMAIL PROTECTED] AND [EMAIL PROTECTED];
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
_______________________________________________ mythtv-users mailing list [EMAIL PROTECTED] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
