[mythtv-users] Copying channel definitions from one instance of MythTV to another

[Jay Foster]

On 06/02/2015 01:10 AM, Simon Hobson wrote:
> Phill Edwards <philledwards at gmail.com> wrote:
>
>> Setting up the channels on the new MythBackend seems painful. For example, at the completion of the scan (Australian DVB-T) it says that there are duplicate channel numbers and asks me to enter a channel number for each and every one of the 90 or so channels it's found.
>
> Ouch !
> Not too sure if this will help too much, but this script might be the basis for something to build on :
> https://www.mythtv.org/wiki/Database_editing_script
> Over here it's much simpler - but the channel numbers make no sense whatsoever and we have a pile of "rubbish" (shopping channels and such). So a long time ago I wrote a script to set the channel numbers etc immediately after a scan.
>
>>From what you write, it sounds like you have a lot of duplicates, so you'll have top figure out how to identify which is which (perhaps by joining with the multiplex table ?) and only keeping active the ones you want.
>
> It does take some setting up and maintaining, but given how TPTB seem to like having a shuffle from time to time - and hence forcing a retune/rescan - it saves over having to do it all manually in the channel editor.
>
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>
You might take a look at the 'mythconverg_backup.pl --backup_xmltvids' 
command.  It might be useful with the above mentioned script or for use 
with mysql directly.  You might use it with your previous system to get 
a list of mysql statements that you can then feed into your new setup.
Jay