<!DOCTYPE html><html><head>
<style type="text/css">body { font-family:'DejaVu Sans'; font-size:13px}</style>
</head>
<body>On Tue, 02 Jun 2015 04:30:07 +0100, Phill Edwards <philledwards@gmail.com> wrote:<br><br><blockquote style="margin: 0 0 0.80ex; border-left: #0000FF 2px solid; padding-left: 1ex"><div dir="ltr"><br><div>Is there a way to export the channel information I have in the original MythBackend and importing that into the new one?<div><br></div><div>I also found this - <a href="https://www.mythtv.org/wiki/Database_Backup_and_Restore#Restore_xmltvids_after_a_channel_scan">https://www.mythtv.org/wiki/Database_Backup_and_Restore#Restore_xmltvids_after_a_channel_scan</a> - but it appears that it will just UPDATE already-defined channels with XMLTV IDs. I'm trying to find a way of importing all the channel information. Is this possible?</div></div></div>
</blockquote><br><div>I haven't tried it on 2 databases, but I suspect mythupchuk (<a href="https://github.com/StarsoftAnalysis/mythupchuk">https://github.com/StarsoftAnalysis/mythupchuk</a>) should be able to do this.</div><div><br></div><div>mythupchuk --fileupdate channels.list</div><div><br></div><div>will dump your good channel table to a text file, which you can then use to update existing channels in your new database:</div><div><br></div><div>mythupchuk --dbupdate --nograbber --nogeticons channels.list (as a dry run, add --commit to effect it)</div><div><br></div><div>It will match channels by sourceid & serviceid so, as long as you use the same sourceid and have already scanned, the channel number, visibility, callsign & name for those channels should be updated. </div><div><br></div><div>The perl script is designed to derive xmltvids automatically from a (UK) grabber, but if you hack it to also dump them out to the text file, then you can migrate them at the same time.</div><div><br></div><div>You'll be left with duplicate channels (serviceids), which you'll have to clean up manually.</div><div><br></div><div>All conjecture of course! Back up before experimenting...</div><div><br></div><div><br></div><div><br></div><br></body></html>