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

[Scott Pouliot]

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.

Hope this helps...the guys on the list helped me big time with this one  ;-)

Scott 

-----Original Message-----
From: mythtv-users-bounces at mythtv.org
[mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Edward Allen
Sent: Wednesday, March 03, 2004 8:49 PM
To: Discussion about mythtv
Subject: Re: [mythtv-users] Moving recordings from one MythTV machine
toanother?

On Mar 3, 2004, at 5:14 PM, stan wrote:

> Can I move a recording I've made on one MythTV machien to another, and 
> play it there?
>
> If so, how do I acomplish this?

Step 1)  Copy the .nuv file.   (Naming scheme is 
CHANID_STARTTIME_ENDTIME.nuv)
Step 2)  Edit the database.  The following works:

UPDATE recorded SET starttime='STARTTIME', hostname='HOSTNAME' WHERE
starttime='STARTTIME' AND chanid='CHANID'