[mythtv-users] Migrating recordings

[ray cielencki]

>That's it, that is the only other thing you need to do for
>myth to find the recordings. However, there is a gotcha.
>If you try to "update recorded set hostname='newhost' where
>hostname='oldhost';" it will screw up the TIMESTAMP fields.
>You would need to update the starttime and endtime for each
>row to their current values in the same UPDATE command to
>avoid this problem.

UPDATE recorded SET hostname='newhost',starttime=starttime,endtime=endtime 
WHERE hostname='oldhost';

would avoid this problem. also, be aware that other tables have hostname 
specific stuff as well, most importantly the settings table.

/rr