Update MySQL 5.1 to latest 5.6 version | Page 19

Discussion in 'Area 51 - Testing Area' started by Sebastiii, April 15, 2013.

  1. elliottmc
    • Premium Supporter

    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
    The more I think about this fix, the more I think there are options to go wrong on upgrade. I have seen this personally.



    My feeling is that we should keep this as simple as possible. Install MySQL 5.6 on new installation but not change anything on upgrade.

    Then if someone has a working system and they choose to not upgrade MySQL, then can carry on as before. However, if they want to upgrade MySQL they can do a complete clean install.

    Sure, a complete install is a pain, but far less then if an upgrade goes wrong and you then have to do it anyway.
     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. netexplorer
    • Premium Supporter

    netexplorer MP Donator

    Joined:
    January 21, 2009
    Messages:
    727
    Likes Received:
    69
    Ratings:
    +101 / 1
    Home Country:
    Germany Germany
    Show System Specs
    Hi,
    i have already installed MP 1.5 with my current MySQL 5.1 installation. What is the best way to upgrade to V.5.6? Use the installer on first post anyway, or should i use a procedure described in Wiki?
     
  4. Sebastiii
    • Team MediaPortal

    Sebastiii Development Group

    Joined:
    November 12, 2007
    Messages:
    16,269
    Likes Received:
    6,221
    Gender:
    Male
    Location:
    France
    Ratings:
    +10,229 / 9
    Home Country:
    France France
    Show System Specs
    First post should do the trick :)
     
  5. netexplorer
    • Premium Supporter

    netexplorer MP Donator

    Joined:
    January 21, 2009
    Messages:
    727
    Likes Received:
    69
    Ratings:
    +101 / 1
    Home Country:
    Germany Germany
    Show System Specs
    Hi,
    so I go ahead with this and ran the installer.
    After the setup completes, i checked the tables with Workbench and they are still in Mysam format.
    Then i try to convert the tables with the provided SQL code, but the record and program table fails with index to long error.
    But i want to use InnoDB to get a better stability.
    Google didn't help with any solution, so i test some options with Workbench.
    The manual option to Alter the table to InnoDB results with success!
    But row format was set to Dynamic, so i try again to convert the table from Dynamic to Compact and this worked too.
    Both steps in one action results also with error. I have to do it step by step.
    Now i have a working DB. I hope this maybe help someone else.
     
  6. markus_g

    markus_g Portal Pro

    Joined:
    August 12, 2006
    Messages:
    104
    Likes Received:
    38
    Gender:
    Male
    Ratings:
    +56 / 0
    Home Country:
    Australia Australia
    Show System Specs
    Hi,
    If doing a complete install to upgrade MYSQL. Will a backup using 'backup settings' from a MYSQL 5.1 database work as a restore to a MySQL 5.6 version?

    Regards,
    Markus_g
     
  7. megahorst
    • Super User

    megahorst Super User

    Joined:
    July 8, 2006
    Messages:
    879
    Likes Received:
    173
    Ratings:
    +272 / 0
    Home Country:
    Germany Germany
    Show System Specs
    • Thank You! Thank You! x 1
  8. D3ltoroxp
    • Premium Supporter

    D3ltoroxp MP Donator

    Joined:
    June 1, 2008
    Messages:
    3,308
    Likes Received:
    133
    Gender:
    Male
    Ratings:
    +207 / 9
    Home Country:
    Germany Germany
    Show System Specs
    Hi is this right, the full installer is for users they have MP1.5 with MySQL 5.1 and would update to SQL 5.6 without new installation ?
     
  9. Sebastiii
    • Team MediaPortal

    Sebastiii Development Group

    Joined:
    November 12, 2007
    Messages:
    16,269
    Likes Received:
    6,221
    Gender:
    Male
    Location:
    France
    Ratings:
    +10,229 / 9
    Home Country:
    France France
    Show System Specs
    Hi,
    This old installer permit to upgrade existing installation for 1.5.0 (don't exactly remember) this code was ported in next MP release but only on fresh install.
     
  10. D3ltoroxp
    • Premium Supporter

    D3ltoroxp MP Donator

    Joined:
    June 1, 2008
    Messages:
    3,308
    Likes Received:
    133
    Gender:
    Male
    Ratings:
    +207 / 9
    Home Country:
    Germany Germany
    Show System Specs
    I will not make a fresh install, so i would updated only the mysql database and after this i will update MP to 1.6. So with this old installer its the right way for me to become mysql 5.6 without fresh install ?
     
  11. Sebastiii
    • Team MediaPortal

    Sebastiii Development Group

    Joined:
    November 12, 2007
    Messages:
    16,269
    Likes Received:
    6,221
    Gender:
    Male
    Location:
    France
    Ratings:
    +10,229 / 9
    Home Country:
    France France
    Show System Specs
    It should yes :)
     
    • Thank You! Thank You! x 1
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!