MP1-4341 Add possibility to Deploy Tool to upgrade MySQL dB | Page 4

Discussion in 'Area 51 - Testing Area' started by Sebastiii, January 24, 2014.

  1. Sebastiii
    • Team MediaPortal

    Sebastiii Development Group

    Joined:
    November 12, 2007
    Messages:
    16,239
    Likes Received:
    6,201
    Gender:
    Male
    Location:
    France
    Ratings:
    +10,200 / 9
    Home Country:
    France France
    Show System Specs
    Will update installer on first post :)
    It should be able to switch from MyISAM to InnoDB on upgrade (but only happening on MySQL 5.6 installed by deploytool (i.e 5.6.10)).
    Stay tuned :)


     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. Sebastiii
    • Team MediaPortal

    Sebastiii Development Group

    Joined:
    November 12, 2007
    Messages:
    16,239
    Likes Received:
    6,201
    Gender:
    Male
    Location:
    France
    Ratings:
    +10,200 / 9
    Home Country:
    France France
    Show System Specs
    Installer updated in first post :)
    So for best testing :
    Install MP 1.5.0 (MySQL 5.1) -> scan some channel -> Install this installer (first page) -> it should install MySQL 5.6 + Migration from MyISAM to InnoDB :)
     
  4. elliottmc
    • Team MediaPortal

    elliottmc Retired Team Member

    Joined:
    August 7, 2005
    Messages:
    14,927
    Likes Received:
    4,011
    Gender:
    Male
    Location:
    Cardiff, UK
    Ratings:
    +5,503 / 13
    Home Country:
    United Kingdom United Kingdom
    Show System Specs
    If you want this in 1.7.0, we NEED testing today!!!!!

    Even then, we can't promise, but the merge window should be closed.
     
    • Like Like x 1
  5. elliottmc
    • Team MediaPortal

    elliottmc Retired Team Member

    Joined:
    August 7, 2005
    Messages:
    14,927
    Likes Received:
    4,011
    Gender:
    Male
    Location:
    Cardiff, UK
    Ratings:
    +5,503 / 13
    Home Country:
    United Kingdom United Kingdom
    Show System Specs
    Oh, and we will need your logs once TV service starts up.
     
  6. elliottmc
    • Team MediaPortal

    elliottmc Retired Team Member

    Joined:
    August 7, 2005
    Messages:
    14,927
    Likes Received:
    4,011
    Gender:
    Male
    Location:
    Cardiff, UK
    Ratings:
    +5,503 / 13
    Home Country:
    United Kingdom United Kingdom
    Show System Specs
    @Sebastiii will correct me if I am wrong, but I think this will still work fine if you update from 1.6.0 or if you have already updated to MySQL 5.6, so your testing is still useful.
     
    • Great Idea! Great Idea! x 1
  7. breese
    • Team MediaPortal

    breese Retired Team Member

    Joined:
    July 11, 2011
    Messages:
    3,903
    Likes Received:
    325
    Gender:
    Male
    Occupation:
    Sr. Systems Engineer
    Location:
    Arlington Heights, Illinois
    Ratings:
    +768 / 0
    Home Country:
    United States of America United States of America
    Show System Specs
    Because my server is running a few web sites and already have MySQL 5.6 installed, I have decided to test this installer as a upgrade / reinstall.

    Upgrade_001.jpg Upgrade_002.jpg
    Because this is an upgrade, should the installer be asking me to also install Lav and Titan?
    They are already installed. Or should I chose a different option?
    Upgrade_003.jpg Upgrade_004.jpg

    I have aborted the install until I hear something
    Also, is a switch I can add to the installer to create a detailed log?
     
    Last edited: February 8, 2014
    • Like Like x 2
  8. elliottmc
    • Team MediaPortal

    elliottmc Retired Team Member

    Joined:
    August 7, 2005
    Messages:
    14,927
    Likes Received:
    4,011
    Gender:
    Male
    Location:
    Cardiff, UK
    Ratings:
    +5,503 / 13
    Home Country:
    United Kingdom United Kingdom
    Show System Specs
    There is probably a newer version of LAVF and TitanExtended available than the one you have installed.

    If you are not sure, update with MPEI first, then install.

    In order for you to test the latest changes, you need to get this installed, then when you restart the TV service, it should update your database. Need logs from this and make sure everything works well afterwards.
     
  9. breese
    • Team MediaPortal

    breese Retired Team Member

    Joined:
    July 11, 2011
    Messages:
    3,903
    Likes Received:
    325
    Gender:
    Male
    Occupation:
    Sr. Systems Engineer
    Location:
    Arlington Heights, Illinois
    Ratings:
    +768 / 0
    Home Country:
    United States of America United States of America
    Show System Specs
    I will move forward... current Lav is 59.1 Not sure about the Titan...
     
  10. breese
    • Team MediaPortal

    breese Retired Team Member

    Joined:
    July 11, 2011
    Messages:
    3,903
    Likes Received:
    325
    Gender:
    Male
    Occupation:
    Sr. Systems Engineer
    Location:
    Arlington Heights, Illinois
    Ratings:
    +768 / 0
    Home Country:
    United States of America United States of America
    Show System Specs
    All seems to have gone ok but on the first startup of the client it took a long time to get beyond the initialization screen...
    The client log is filled with
    [2014-02-08 09:28:00,327] [Log ] [MPMain ] [DEBUG] - D3D FullRender: MP focus

    Sorry for the zip files but someone / somehow I can only upload a single file at a time again.
    btw: the 5.6 DB looks good from what I see
     
  11. Sebastiii
    • Team MediaPortal

    Sebastiii Development Group

    Joined:
    November 12, 2007
    Messages:
    16,239
    Likes Received:
    6,201
    Gender:
    Male
    Location:
    France
    Ratings:
    +10,200 / 9
    Home Country:
    France France
    Show System Specs
    I suppose :)
     
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!