[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