Transfer Entire TVServer / Database (2 Viewers)

Britton

Portal Member
December 13, 2014
5
0
39
Home Country
United States of America United States of America
New to MediaPortal and been lurking the forums, wiki and the rest of the interweb for several weeks now. I have been a WMC user for a few years and am ready to make the switch to running MediaPortal on my systems. That said, I've been working through the configuration kinks and such on my office computer and want to take the TVServer setup that I have here and move it onto my main HTPC that will act as the TVServer for itself and several other TVs throughout my home. It's been essential for me to keep the wife happy and not interrupt the current TV setup so she doesn't miss any episodes of the Real Desperate Housewives of WTF, or whatever reality crap she prefers.

That said, I've gone through quite a bit of work to create the channel mapping between the lineup pulled from my HDHomeruns (2x ATSC dual tuners and 1 Prime cablecard triple tuner...) and the channel lineup pulled from Schedules Direct. As it seems to be fairly well known, the channel call-signs provided by the HDHR Prime / Cable Company differ from what gets pulled from Schedules Direct. I've spent a lot of time:
  • Scanning the channels from my tuners
  • Renaming all of the channels so their call-signs match what SD expects (there were LOTS, hundreds...this took a while :) )
  • Pulling down the guide data after the channel mapping has been established
  • Then renaming each channel again so the MediaPortal front end has a nice human-readable channel name (e.g. renamed DSCHD to Discovery Channel HD) along with assigning logos to each channel
With all that in mind, I don't want the TVServer to reside on my office machine as it gets rebooted, is a power hog, etc...

I've tried doing an export from the TVServer Configuration and re-importing the XML into the new TVServer, but the channel mapping between SD and my HDHR lineups isn't there. If I pull down the guide data, I get a ton of "No Data..." errors as I did before renaming all of the channels initially on my office computer.

I've tried manually copying the database from C:\ProgramData\MySQL\MySQL Server 5.6\data from the office to the HTPC and have also tried manually copying the data from C:\ProgramData\Team MediaPortal. This usually results in the TVServer or MySQL services failing to start.

I really don't want to have to go back through and rename each channel to create the mapping between SD and my HDHR lineup -- anyone have any ideas?

Thanks in advance
 

mm1352000

Development Group
  • Team MediaPortal
  • September 1, 2008
    21,577
    8,222
    Home Country
    New Zealand New Zealand
    Country flag
    Hello and welcome! :)

    If I were you I'd be pursuing the MySQL database copy. Unfortunately I have a feeling it may be the only way to preserve the SD guide data mappings.

    This somewhat technical link may help:
    http://dev.mysql.com/doc/refman/5.6/en/copying-databases.html

    Again, unfortunately the process of copying a database isn't necessarily going to be a walk in the park for a lot of people. If you get stuck, sing out and I'll try to assist if possible.

    Regards,
    mm
     

    Britton

    Portal Member
    December 13, 2014
    5
    0
    39
    Home Country
    United States of America United States of America
    Thanks for the guidance, mm, much appreciated.

    Before I go down the rabbit hole of figuring this out, do you think this is even possible? Is the SD mappings stored in the DB along with the channel info from the initial scan from the HDHR?

    Along with that, I'd like to have a backup mechanism that would allow the TV Server to be transferred to a different machine for things like, OS reinstalls, upgrading to a new HTPC, etc...
     

    mm1352000

    Development Group
  • Team MediaPortal
  • September 1, 2008
    21,577
    8,222
    Home Country
    New Zealand New Zealand
    Country flag
    Before I go down the rabbit hole of figuring this out, do you think this is even possible? Is the SD mappings stored in the DB along with the channel info from the initial scan from the HDHR?
    I'm 100% confident that the SD mapping is stored in the DB Channel table, ExternalId column. It is absolutely possible.
     

    Britton

    Portal Member
    December 13, 2014
    5
    0
    39
    Home Country
    United States of America United States of America
    Awesome -- thank you sir. I'll let you know how it turns out...cross your fingers :)
     

    Britton

    Portal Member
    December 13, 2014
    5
    0
    39
    Home Country
    United States of America United States of America
    Hey mm -- trying to get this to work.

    But having some issues, would you recommend this sequence?
    1. Install TVServer on destination machine
      1. I'm not doing a channel scan or pulling SD listings, I was thinking of literally just installing the components and moving the entire DB thinking ALL of the old machine's contents would be imported when moving the DB.
    2. Install / enable the SD plugin
    3. Import the XML export / backup from the old machine (is this step needed, or does moving the DB itself implicitly do this...?)
    4. Migrate the DB
    Thanks again for the help.
     

    wjw

    Portal Pro
    July 13, 2008
    349
    34
    Home Country
    United Kingdom United Kingdom
    Country flag
    I'm no expert, in the way that mm1352000 is, but if you want extra re-assurance, I have done exactly this in the past. Specifically in regard to rebuilding and reinstalling WIn7 on my system. I used the MySQL Workbench tool and simply exported the database before the rebuild, installed MP from new, deleted the database created as part of the install then imported the old one. Worked perfectly for me.
     

    mm1352000

    Development Group
  • Team MediaPortal
  • September 1, 2008
    21,577
    8,222
    Home Country
    New Zealand New Zealand
    Country flag
    Import the XML export / backup from the old machine (is this step needed, or does moving the DB itself implicitly do this...?)
    This step is unnecessary. As you say, importing the DB will take care of this.
     

    Users who are viewing this thread

    Similar threads

    P.S. - Strangely, the TV Server my single seat setup (1.27 on a modest machine running Windows 10 Pro x64) is working from my office machine MP client. Same exact network, firewall, Defender settings. It's a slightly older version of Win 10 though - I haven't updated to 20Hx on it yet. Maybe I shouldn't (or maybe I should image it...
    P.S. - Strangely, the TV Server my single seat setup (1.27 on a modest machine running Windows 10 Pro x64) is working from my...
    Let me start by asking if anyone has TV Server running PROPERLY on a Windows 10 machine, and if so are you using RTSP or UNC share...
    Replies
    9
    Views
    733
    Have you selected the correct data format on the Schedules Direct web site? For the USA and Canada, the EPG data can be provided by SD in XML format or JSON format. XML format is the old style, and JSON format is the new style. Unfortunately, the TV Server plugin can process only XML format. If you are in fact downloading JSON...
    Have you selected the correct data format on the Schedules Direct web site? For the USA and Canada, the EPG data can be provided...
    I have installed version 1.27on MediaPortal and 1.11.0.2 of the Schedules Direct plugin. I scanned my Hauppauge WinTV dualHD...
    Replies
    4
    Views
    725
    Thanks MM for your help. Last I said I was getting channels but the tuner wasn't tuning any channels. Went through your setup wiki once more and now I have TV again! Thanks again...on to fine tune it now.
    Thanks MM for your help. Last I said I was getting channels but the tuner wasn't tuning any channels. Went through your setup wiki...
    Been using WMC since 2013 using Hauppage DCR-2650 with cable card and Verizon FIOS. Now that MS pulled the plug on EPG data, I...
    Replies
    6
    Views
    589
    OK, this is specifically for people in Belgium (Vlaanderen) who are using Telenet Cable with MediaPortal 2. Next year (Edit: this year, in march 2020) the Telenet provider will stop broadcasting Analog TV and Radio signals on their cable, and make the switch to Digital (DVB-C). The radio signals will disappear completely, so you'll...
    OK, this is specifically for people in Belgium (Vlaanderen) who are using Telenet Cable with MediaPortal 2. Next year (Edit: this...
    OK, this is specifically for people in Belgium (Vlaanderen) who are using Telenet Cable with MediaPortal 2. Next year (Edit: this...
    Replies
    0
    Views
    828
    Same as HTPCSourcer wrote, the process of this plugin is not a mass process. Depending where you download your xmltv.xml file, some websites propose to have a personal file (you choose what are channels in the .xml). An example for french country : It takes 2 minutes an 5 seconds for 4765 programs imported on my system : If...
    Same as HTPCSourcer wrote, the process of this plugin is not a mass process. Depending where you download your xmltv.xml file, some...
    I've finally finished mapping all the channels were scanned from my HDHomeRun over-the-air and cable tuners, which amounts to over...
    Replies
    3
    Views
    684
    Top Bottom