<div><BR><BR><B><I>"Michael T. Dean" <mtdean@thirdcontact.com></I></B> wrote:</div> <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">On 07/26/2007 04:23 AM, Dave Phillips wrote:<BR>> Well I don't recommend this for primetime yet but it at least seemed<BR>> to work for me.<BR>> I ran<BR>> mysqldump -u mythtv -p -t mythconverg record recorded oldrecorded<BR>> recordedprogram recordedrating recordedmarkup recordedseek ><BR>> recordings.sql<BR>><BR>> Then I looked at the output and decided I probably only needed the<BR>> insert statement for the recorded shows.<BR>> So I deleted everything except one insert statement for the "recorded"<BR>> table.<BR><BR>Really, you need all the (appropriate) information from the tables<BR>listed in the HOWTO I mentioned (<BR>http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7 ). You only need to<BR>import entries from record if you want the recording
rules to be moved<BR>over. (You could instead create them on the new system.)<BR><BR><BR>By "appropriate informatoin" I mean you only need the entries that<BR>correspond to the recordings you're moving over. However, since that<BR>would be 1 entry in recorded, oldrecorded, recordedprogram, and<BR>recordedrating, but would be multiple (tens of entries, but not any<BR>consistent number) in recordedmarkup and around (though not exactly)<BR>3600 entries per half hour of recording duration in recordedseek,<BR>finding the right entries is much harder than just importing everything<BR>and "deleting" the "recordings" (no file necessary) you don't want.<BR><BR>> I suspect you are correct about the channel id's but I don't see how<BR>> 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<BR>> channel scan and the old id's got blown away.<BR>> You could still watch the old shows.<BR><BR>The
channel ID and starttime is used as a unique key in most of the<BR>tables you'll be using. If they're identical on more than one<BR>recording, you'll have problems.<BR><BR>> My next step is to cleanup my old backend and then do this completely.<BR><BR>I recommend taking a look at the HOWTO and wish you good luck with the<BR>record uniqueness constraint.<BR><BR>Mike<BR>_______________________________________________<BR>mythtv-users mailing list<BR>mythtv-users@mythtv.org<BR>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users<BR></BLOCKQUOTE><BR> <div>I looked at the list and decided I personally didn't care about the extra tables.</div> <div>From the README</div> <div>$ grep "INSERT INTO \`record\` " mythtv_backup.sql > restore.sql<BR>$ grep "INSERT INTO \`recorded\` " mythtv_backup.sql >> restore.sql<BR>$ grep "INSERT INTO \`oldrecorded\`
" mythtv_backup.sql >> restore.sql<BR>$ grep "INSERT INTO \`recordedprogram\` " mythtv_backup.sql >> restore.sql<BR>$ grep "INSERT INTO \`recordedrating\` " mythtv_backup.sql >> restore.sql<BR>$ grep "INSERT INTO \`recordedmarkup\` " mythtv_backup.sql >> restore.sql<BR>$ grep "INSERT INTO \`recordedseek\` " mythtv_backup.sql >> restore.sql</div> <div> </div> <div><BR><EM><STRONG>Record</STRONG></EM> has the recording rules, which I don't need as I have already recreated them.</div> <div><EM><STRONG>Recorded</STRONG></EM> I did.</div> <div><EM><STRONG>oldrecorded</STRONG></EM> seems to be there only so that Myth knows if I have already recorded the show, but the entries don't "have" to be there.</div> <div><EM><STRONG>recordedprogram</STRONG></EM> has all the detailed information about the records in the recorded table and I should have grabbed this one.</div>
<div><EM><STRONG>recordedrating</STRONG></EM> has the ratings of the shows in the recorded table and I didn't care if I had those or not.</div> <div><EM><STRONG>recordedmarkup</STRONG></EM> has the commercial and cut marks and I didn't care about those </div> <div><EM><STRONG>recordedseek</STRONG></EM> stores a time vs. byte offset mapping (seektable) for each recording in the recorded table to enable accurate forward and backward time skipping, I could have used this one.</div> <div> </div> <div>So like I said this was just my experiment to see if I could at least watch the shows from the old box.</div> <div>And I could.</div> <div>Going forward I think I will probably increment the chanids by some large number( 100000 maybe) before I do the dump from the old machine.</div> <div> </div> <div>I will then do the dump the tables listed below (even though I don't personally need them)</div> <div> </div> <div>mysqldump -u
mythtv -p -t mythconverg recorded recordedprogram recordedrating recordedmarkup recordedseek > recordings.sql</div> <div> </div> <div>(of course if you want you recording rules and want to let myth know about the old shows you could put record and oldrecorded in the list)<BR><BR>Backup my current tables (just in case)</div> <div>Copy over all the video files from the old backend.</div> <div>Stop the new backend.</div> <div>Run the recordings script.</div> <div>mysql -u mythtv -pmythtv mythconverg < recordings.sql <BR>Restart mythbackend.</div><p> 
<hr size=1>Shape Yahoo! in your own image.
<a href="http://us.rd.yahoo.com/evt=48517/*http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7">Join our Network Research Panel today!</a>