[mythtv-users] Moving recordings from one MythTV machine
edward.allen at whiterunkle.com
Thu Mar 4 14:21:51 EST 2004
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
> mythconverg -c > mythtv_backup.sql)
> Then I edited this file down to just the recorded table (I should have
> the markup table, but it was an afterthought). Then I copied the NUV
> 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