Migration help.

Discussion in 'Television (MyTV frontend and TV-Server)' started by wjw, October 15, 2017.

  1. wjw

    wjw Portal Pro

    Joined:
    July 13, 2008
    Messages:
    322
    Likes Received:
    20
    Ratings:
    +34 / 0
    Home Country:
    United Kingdom United Kingdom
    Hi,
    I have decided to replace my existing HTPC with a brand new system. My plan was to migrate all the data first - all done successfully - and then to migrate the MpTvDb from the old machine to the new one using the MySQL Workbench tool - again all worked fine.

    Except that.....
    TVServer now won't work properly because the TV cards are different and it fails to start/stop the database due to an error in getting the card. My assumption at this point is that this is because it's trying to load a card that doesn't exist on the new system.

    Obviously I would like to preserve as much of the old database as possible, largely because it contains all the TVWishList data as well as preferred channel groups and so on, and doing this will save a very large amount of time in trying to rebuild several years of data.



    Obviously one possible solution - I think! - would be to migrate all the tables except for those containing the card and tuning data. Once this is done I could then just rescan on the new cards.

    Would this work OK? If so, can anyone tell me which are the tables I need to leave out of the migration process? The MySQL Workbench make this fairly easy to do once you know the specific tables to handle.
     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. mm1352000
    • Team MediaPortal

    mm1352000 Development Group

    Joined:
    September 1, 2008
    Messages:
    21,541
    Likes Received:
    4,752
    Ratings:
    +8,220 / 17
    Home Country:
    New Zealand New Zealand
    Hi

    In my opinion: unlikely.

    I suspect it's more likely that you have this:
    TV Server Configuration Fails To Start - get_Cards() error

    ...because the name or IP address of your new HTPC is different.
    Update the content of the Server table.
     
  4. wjw

    wjw Portal Pro

    Joined:
    July 13, 2008
    Messages:
    322
    Likes Received:
    20
    Ratings:
    +34 / 0
    Home Country:
    United Kingdom United Kingdom
    As ever, many thanks for your help. I never thought of that one and it would have been a bit simpler! (eventually I guessed at the Card table and just truncated that - a restart repopulated that tale with the new configuration).

    I have just re-done the migration and changed the Server name and everything is just perfect! I assume that I will need to rescan because these are new cards and will do that once I can get the new machine into place with access to the satellite cables.

    Again, thanks for your advice and time.
     
  5. mm1352000
    • Team MediaPortal

    mm1352000 Development Group

    Joined:
    September 1, 2008
    Messages:
    21,541
    Likes Received:
    4,752
    Ratings:
    +8,220 / 17
    Home Country:
    New Zealand New Zealand
    Nice. (y)

    No, you don't need to scan at all.
    Just map (link) the channels to the cards. Much faster.
    Mapping
     
  6. wjw

    wjw Portal Pro

    Joined:
    July 13, 2008
    Messages:
    322
    Likes Received:
    20
    Ratings:
    +34 / 0
    Home Country:
    United Kingdom United Kingdom
    What a speedy service! Again, thanks - that will save a good chunk of time!
     
Loading...

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!