Update MySQL 5.1 to latest 5.6 version (1 Viewer)

elliottmc

Retired Team Member
  • Premium Supporter
  • August 7, 2005
    14,927
    6,061
    Cardiff, UK
    Home Country
    United Kingdom United Kingdom
    Country flag
    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.
     

    netexplorer

    MP Donator
  • Premium Supporter
  • January 21, 2009
    732
    103
    Home Country
    Germany Germany
    Country flag
    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?
     

    netexplorer

    MP Donator
  • Premium Supporter
  • January 21, 2009
    732
    103
    Home Country
    Germany Germany
    Country flag
    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.
     

    markus_g

    Portal Pro
    August 12, 2006
    104
    42
    Home Country
    Australia Australia
    Country flag
    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.

    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
     

    D3ltoroxp

    MP Donator
  • Premium Supporter
  • June 1, 2008
    3,308
    205
    Home Country
    Germany Germany
    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 ?
     

    Sebastiii

    Development Group
  • Team MediaPortal
  • November 12, 2007
    16,557
    10,376
    France
    Home Country
    France France
    Country flag
    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.
     

    D3ltoroxp

    MP Donator
  • Premium Supporter
  • June 1, 2008
    3,308
    205
    Home Country
    Germany Germany
    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 ?
     

    Users who are viewing this thread

    Similar threads

    • Sticky
    Just for your information: couldn't find the ns*.tmp file...
    Just for your information: couldn't find the ns*.tmp file...
    Pre Releases are provided as a way for the community to test and give feedback on all the exciting things we have lined up for the...
    Replies
    39
    Views
    1K
    Hallo, Since the update to MP1 27 pre, the refresh rate display no longer works correctly. The font is too small and illegible. The display can be reached with "Shift, 1". Andreas
    Hallo, Since the update to MP1 27 pre, the refresh rate display no longer works correctly. The font is too small and illegible. The...
    Pre Releases are provided as a way for the community to test and give feedback on all the exciting things we have lined up for the...
    Replies
    2
    Views
    819
    • Sticky
    We have just released MediaPortal 1.27 Highlights of this release Bugfixes: [MP1-5050] - GUIHome should not be copied next to the mediaportal executable [MP1-5051] - Music Playback fails with ReplayGain enabled and no ReplayGain Information in song [MP1-5053] - TV framerate is not parsed from tsbuffer Since Pre-Release ...
    We have just released MediaPortal 1.27 Highlights of this release Bugfixes: [MP1-5050] - GUIHome should not be copied next to...
    We have just released MediaPortal 1.27 Highlights of this release Bugfixes: [MP1-5050] - GUIHome should not be copied next to...
    Replies
    0
    Views
    2K
    I thinks this is the first time I've installed MP on all my machines without a single IO error 32. Good work guys, thanks!
    I thinks this is the first time I've installed MP on all my machines without a single IO error 32. Good work guys, thanks!
    We have just released MediaPortal 1.26 - Winter is coming... Highlights of this release Bugfixes: [MP1-5031] - Fix Invalid File...
    Replies
    1
    Views
    1K
    Pre Releases are provided as a way for the community to test and give feedback on all the exciting things we have lined up for the next release. We allocate about one month for Pre Release testing. In that time we will only fix bugs, after which comes the final release! Highlights of this release Bugfixes: [MP1-5031] - Fix Invalid...
    Pre Releases are provided as a way for the community to test and give feedback on all the exciting things we have lined up for the...
    Pre Releases are provided as a way for the community to test and give feedback on all the exciting things we have lined up for the...
    Replies
    0
    Views
    1K
    Top Bottom