[mythtv-users] Migrating recordings

ray cielencki mythtv at rayslinky.com
Tue Sep 30 07:52:01 EDT 2003


At 06:34 09/30/2003, Bruce Markey wrote:
>>UPDATE recorded SET 
>>hostname='newhost',starttime=starttime,endtime=endtime WHERE 
>>hostname='oldhost';
>>would avoid this problem.
>
>I don't think so. AFAIK you can't use the string "starttime" or
>such as a variable to indicate the existing starttime of the
>record. You would need individual commands for each row with
>the specific values for the timestamps. Further, you'd need
>WHERE clauses for chanid and starttime so that the starttime and endtime 
>would only be applied to that one row. It could
>be scripted but why bother. Deleting then using the INSERT
>lines from the backup takes less than a minute.
>
>--  bjm


it works for me with 'mysql  Ver 11.18 Distrib 3.23.56, for 
redhat-linux-gnu (i386)'

/rr



More information about the mythtv-users mailing list