Upgrade of 1.5 with 1.6 does not upgrade MySQL 5.1 to 5.6 | Page 2

Discussion in 'Installation, configuration support' started by bartch, January 3, 2014.

  1. Iwen

    Iwen Portal Pro

    Joined:
    August 14, 2007
    Messages:
    464
    Likes Received:
    24
    Ratings:
    +32 / 0
    Home Country:
    Germany Germany
    That is exactly what I was thinking.



    You installed MySQL 5.6 but configured the database connection with MP1.5. So, in this case MP creates 'mptvdb' with MyISAM format.
    After that you updated MP to 1.6. The installer found an existing database and left it unchanged. That means, that your tables remain in the same format as before.
    To overcome this situation you have to delete the 'mptvdb' database (use the Workbench) and configure the TV-Server database connection again. In your tutorial these are the steps 6-9. After that MP1.6 will create a new database with the new InnoDB format.

    To check the format you can use this sql command (also in the Workbench, when you have connected to your database):
    Code (Text):
    1. SELECT `TABLE_NAME`, `ENGINE` FROM `information_schema`.`TABLES` WHERE `TABLE_SCHEMA` = 'mptvdb';
     
    • Like Like x 1
    • Thank You! Thank You! x 1
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. mrspock

    mrspock Portal Pro

    Joined:
    September 14, 2008
    Messages:
    124
    Likes Received:
    20
    Gender:
    Male
    Location:
    Madrid
    Ratings:
    +33 / 0
    Home Country:
    Spain Spain
    Show System Specs
    Thanks a lot to both, @mm1352000 and @Iwen, for your great help. :D

    I checked the format, with the sql command, and you both were right (I was not aware when the db is created and that it was in the old format). I did as Iwen told, and now is InnoDB format. (y)

    I will edit my original post to modify step 1 and to remove the idea of installing MP 1.6 after that. This will help other users, as well.

    That documentation does not provide further information to me, as the main things are explained in the screenshots. Reading that screenshots is why I decided my installation options, as I was not able to find recommendations for MP.
    The "best for me" is what is "best for MP" and the performance of my HTPC (99% dedicated to MP). I do not have an especial interest of customising it as far as MP works ok, but just wanted to use the same options used in the MP 1.6 installer when doing a fresh install (I trust on the dev team knowledge).
     
    Last edited: January 6, 2014
  4. Sigpi007

    Sigpi007 Portal Pro

    Joined:
    November 14, 2012
    Messages:
    104
    Likes Received:
    19
    Gender:
    Male
    Location:
    Chicago, IL
    Ratings:
    +33 / 0
    Home Country:
    United States of America United States of America
    Show System Specs
    Thanks Mrspock for the detailed walk through. It was very helpful this evening. Much appreciated.

    One thing I noticed... Specific to functionality related to Cablecards... Is the the "CAM enabled" flags and "simultaneous streams" values were not backed up in the TV server settings export. As it's newer functionality, I can understand why this would be the case. Anyone using Cablecards following this upgrade process will need to re-enable those settings or they'll get an "all cards busy" error message when they test channels after upgrading.
     
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!