[mythtv-users] Migrating recordings

[Andrew Ingram]

> >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.

Many thanks for the replies. In the end I used the mysqldump & edit the
dump file method since I do that all the time so it's very quick and
easy for me.

Thanks.
Andrew