[mythtv-users] Moving recordings from one MythTV machine toanother?

[Edward Allen]

On Mar 4, 2004, at 9:05 AM, Scott Pouliot wrote:

> One problem I noticed with this though is you lose all the flagged
> commercials.  So I assume those are stored in recordedmarkup, and 
> you'd need
> to export those records as well to keep your commercials flagged.  
> It's not
> a huge deal...more of a minor annoyance.  I copied @ 50 recordings 
> last week
> to my "new" Myth box...worked like a charm.
>

> What I did was export the DB to a .SQL file (mysqldump -u mythtv 
> -pmythtv
> mythconverg -c > mythtv_backup.sql)
>
> Then I edited this file down to just the recorded table (I should have 
> taken
> the markup table, but it was an afterthought).  Then I copied the NUV 
> files
> to the new server, and ran: mysql -u mythtv -pmythtv mythconverg <
> mythtv_backup.sql to re-import all the records into my database.
>
> Problem solved.

This will work, although I recommend nuvexport for this process 
(mentioned earlier by Harold Brown).

I believe Stan was asking about moving recordings around between a 
slave and master backend, not two separate myth setups.

For this the update sql command is perfect.  recordedmarkup matches to 
a recording by chanid and starttime, so it is not affected by a change 
in hostname (or for that matter endtime, title, subtitle, etc.).

BTW:  You can always reflag commercials using mythcommflag.