<br><br><b><i>Ken Mandelberg <km@mathcs.emory.edu></i></b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> Dave<br><br>I would like to see the script. It seemed to me that merging was going <br>to be more complicated than migrating to a new database because of <br>conflicts in some fields. For example the chanid ssems to be instance <br>specific even for two masters using the same lineup.<br><br>Ken<br><br>=====<br><br> Dave Phillips <family_of_phillips@yahoo.com> Wrote<br><br>Hi Ken,<br> I am in the same situation.<br> I haven't seen any detailed steps for it yet.<br> But here is what I was going to do when I had the time.<br> 1. extract(backup) the contents of the recordings database from the <br>master I am retiring.<br> 2. copy all of the recordings from the retiring boxes myth/tv <br>directory to the new single master /myth/tv directory<br> 3. Import(restore) the contents into
the new single masters database <br>using the script generated in step 1.<br><br> Of course I would do all those things you are supposed to do like <br>backup the database before, blah blah blah.<br><br> Now I "had" the script to extract what was needed and create a series <br>of insert statements but I can't find it right now.<br> I will post it tonight if I can dig it up.<br><br> Dave<br><br>Ken Mandelberg <km@mathcs.emory.edu> wrote:<br> I have two independent master backends, and I would like to convert one<br>into a non-master logically merging the contents.<br><br>Any pointers on this?<br>_______________________________________________<br>mythtv-users mailing list<br>mythtv-users@mythtv.org<br>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users<br></km@mathcs.emory.edu></family_of_phillips@yahoo.com></blockquote>Well I don't recommend this for primetime yet but it at least seemed to work for me.<br>I ran <br>mysqldump -u mythtv -p -t mythconverg record
recorded oldrecorded recordedprogram recordedrating recordedmarkup recordedseek > recordings.sql<br><br>Then I looked at the output and decided I probably only needed the insert statement for the recorded shows.<br>So I deleted everything except one insert statement for the "recorded" table.<br><br>LOCK TABLES `recorded` WRITE;<br>/*!40000 ALTER TABLE `recorded` DISABLE KEYS */;<br>INSERT INTO `recorded` VALUES (1009,'2006-11-06 21:00:00','2006-11-06 22:00:00',<br>'Smallville','Fallout','Clark learns Raya managed to escape from the Phantom Zon<br>e and has come to see him; Baern (Bow Wow), a killer who also escaped, takes them on as revenge for his imprisonment.','Action','mythtv',0,0,0,0,1,'Default',69,<br>'SH462144','EP4621440127','2006-12-18 13:48:57',4149659146,0,0,'2006-11-02',0,0,<br>0,0,1,0,'1009_20061106210000.nuv','2006-11-06 21:00:00','2006-11-06 22:00:00','D<br>efault','Default',1,0,0);<br>/*!40000 ALTER TABLE `recorded` ENABLE KEYS */;<br>UNLOCK
TABLES;<br><br><br>I copied over the nuv file to the new machine /myth/tv<br>1009_20061106210000.nuv<br>Stopped the mythbackend on the new machine<br>Ran the insert statement.<br>mysql -u mythtv -pmythtv mythconverg < single.sql <br>Restarted the backend <br>I then went to the myth frontend on the new machine and watched the copied over show.<br>A couple of things I still need to fix though.<br>The show wasn't in it's correct category so I suspect that was in one of the insert statements I didn't bother with.<br>As well for some reason the show wouldn't display on my xbox frontend, but it previewed fine and I had no problem previewing or watching it on my new backend machine.<br><br>I suspect you are correct about the channel id's but I don't see how it would matter for a show that is already recorded.<br>Sort of like if you had some shows recorded and then had to do a new channel scan and the old id's got blown away.<br>You could still watch the old
shows.<br><br>My next step is to cleanup my old backend and then do this completely.<br><br><p> 
<hr size=1>Looking for a deal? <a href="http://us.rd.yahoo.com/evt=47094/*http://farechase.yahoo.com/;_ylc=X3oDMTFicDJoNDllBF9TAzk3NDA3NTg5BHBvcwMxMwRzZWMDZ3JvdXBzBHNsawNlbWFpbC1uY20-">Find great prices on flights and hotels</a> with Yahoo! FareChase.