[mythtv-users] Migrating recordings

[Bruce Markey]

Andrew Ingram wrote:
> Hi List,
> 
> I'm migrating from an old mythbox to a new one. I've got MythTV up and
> running on the new one but I'd like to copy over the existing
> recordings. Can anyone tell me what I need to do?

First, make sure you have a good backup of your database:

http://www.mythtv.org/docs/mythtv-HOWTO-21.html#ss21.5

> Obviously I need to copy over the files of the recordings, but what
> else? Would copying over the mythconverg.recorded table entries be
> enough? (changing the hostname column as I went).

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.

An easier way is to copy the INSERT INTO recorded lines from
your backup into a file and edit the hostnames. Next, after
you know you have a good backup ;-), "delete from recorded;"
then run the file with the edited INSERTs.

I believe someone added functionality to remap the hostname
but I think you will be better off if you just change the
hostname fields now and be done with it.

--  bjm