[mythtv-users] Moving recordings from one MythTV machinetoanother?

Scott Pouliot spouliot at scpsoftware.net
Thu Mar 4 15:14:33 EST 2004


Ahhh...I didn't realize you could re-flag a recording.  I'll have to hunt
down info in the docs.  I have a few I'd like to get back  ;-)

Scott 

-----Original Message-----
From: mythtv-users-bounces at mythtv.org
[mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Edward Allen
Sent: Thursday, March 04, 2004 2:22 PM
To: Discussion about mythtv
Subject: Re: [mythtv-users] Moving recordings from one MythTV
machinetoanother?

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.




More information about the mythtv-users mailing list