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

[Hika van den Hoven]

Hoi Simon,

Tuesday, June 2, 2015, 10:10:17 AM, you 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.


If you are familiar with phpmyadmin? You can export the channel table
and if it's dvb the dtv-multiplex table and import them in the new
database. You have to watch the sourceid field in both tables. This
must match the sourceid in the videosource table. This field comes
back again in the cardinput table. If you create the source the normal
way it will probably have a different value.


Tot mails,
  Hika                            mailto:hikavdh at gmail.com

"Zonder hoop kun je niet leven
Zonder leven is er geen hoop
Het eeuwige dilemma
Zeker als je hoop moet vernietigen om te kunnen overleven!"

De lerende Mens