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
    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
    727
    101
    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
    727
    101
    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
    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
    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,434
    10,256
    France
    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
    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 (Users: 0, Guests: 1)

    OP Similar threads Forum Replies Date
    J Update .NET framework? Improvement Suggestions 0
    G Update von MediaPortal Installationsprobleme? 0
    morpheus_xx [Evaluate] Update to VS 2019? MediaPortal 2 4
    Golf4 Nach Windows-Updates läuft TV-Plugin nicht mehr Allgemeines Support- und Diskussionsforum 0
    B MPEM update list never completes. General Support 0
    JJDoherty Updated DTT frequencies for Ireland... Submit: EPG-Grabbers and tuningdetails 1
    Dark Eyes Updated to Windows 10, now TVServer won't work Installation, configuration support 1
    R [solved] Files moved to new location - Easy way to update database? My TVSeries 7
    M.Hulot Moving Pictures lässt sich nach Windows-Update nicht mehr öffnen Plugins & Erweiterungen 1
    R Files moved to different location - Easy way to update database? Moving Pictures 2
    k12158 [solved] Kein direkter Wechsel von TV-Kanal zu TV-Kanal mehr nach Update? Allgemeines Support- und Diskussionsforum 16
    ajs Mediaportal update to .Net 4.6.2+ MediaPortal 1 13
    Mr6686 [solved] Titan skin broken since update to 1.23 Installation, configuration support 6
    B TV-Server Auto-Update mptvdb after x hours General Support 0
    Terra LAVFilter Plugin cannot be updated (MP1.23) MediaPortal 1 Plugins 10
    TLD Windows 10 1903 feature update General Support 3
    azzuro [Pending] Update MP1 to VisualStudio 2019 MediaPortal 1 36
    A Problem Windows 10 64 bit prof. Update auf Version 1903(gelöst) Installationsprobleme? 0
    T No TV after updating Windows 10 to latest Version 1903 / OS build 18362.175 (logs attached) General Support 2
    M [solved] Updated Swedish translation for MP 1.24 Submit: Localization of MediaPortal and DeployTool 0
    framug 1.22.0 BasicHome Editor settings for DefaultWide HD skin not kept when update 1.22 3
    Neoculture Bulk file name update My TVSeries 6
    HTPCSourcer [Evaluate] MP2-Updates do not remove the GUID of previous installs MediaPortal 2 13
    Rob Hexenmeister [solved] Latests Media Handler - Skinning an updating window or control Fanart Handler 26
    H [solved] Problem bei Update auf 1.21 Installationsprobleme? 4
    Similar threads

























    Top Bottom