Update MySQL 5.1 to latest 5.6 version (1 Viewer)

Sebastiii

Development Group
  • Team MediaPortal
  • November 12, 2007
    16,447
    10,273
    France
    France France
    Country flag
    Maybe it will be possible to add a menu in deploy to ask user if they want to update MySQL 5.1 to 5.6 with a warning (that it can failed and it will migrate all db from 5.1 to 5.6)

    But in worst case, the 5.1 database is not deleted :)

    If i'm in mood, i can try to look @ the code to add this selection (on upgrade).
     

    D3ltoroxp

    MP Donator
  • Premium Supporter
  • June 1, 2008
    3,308
    205
    Germany Germany
    And how Change the old db in the new one ? Export Import ? or is this done by your Setup?
     

    D3ltoroxp

    MP Donator
  • Premium Supporter
  • June 1, 2008
    3,308
    205
    Germany Germany
    So i think it looks very good and i use now MySQL 5.6 with InnoDB. So all is automaticly switched to the new DB. So i can delet / uninstall the old MySQL 5.1 ?

    After view test all seems to works fine. All TV Channels are there and no error's. So i think i have perfekt update to the new one. Thanks alot !!

    Tomorrow i update then to MP 1.6 final after testing in action tonight.
     

    Attachments

    netexplorer

    MP Donator
  • Premium Supporter
  • January 21, 2009
    727
    101
    Germany Germany
    Country flag
    Are you shure your tables are in InnoDB format? Have checked this with Workbench?
     

    Hawkeye

    Portal Pro
    January 29, 2005
    548
    87
    Halle (Saale)
    Germany Germany
    Country flag
    Hm i don't know, but the dos window tells me innodb is default... What is workbench ? And how can i check it with that ?
    But that doesn't mean that the tables are innodb. It could be they are (then this installer would have converted them) but most likely they aren't because the db already existed.

    Workbench is a GUI tool for MySQL. But you can also check the tables from cmd by this query:
    Code:
    SELECT `TABLE_NAME`, `ENGINE` FROM `information_schema`.`TABLES` WHERE `TABLE_SCHEMA` = 'mptvdb';
     
    Last edited:

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Hungary Hungary
    Here is my solution to migrate the MyISAM to InnoDB:

    1. Stop the TvServer service
    2. Open a command promp and go to the MySql 5.6 folder: cd "\Program Files\MySQL\MySQL Server 5.6\bin"
    3. mysqldump -u root -pMediaPortal mptvdb>c:\mptvdb.sql
    4. open the c:\mptvdb.sql with notepad and replace all MyISAM texts to InnoDB, save it and exit
    5. mysql mysql -u root -pMediaPortal <c:\mptvdb.sql
    6. Start the TvServer service
     

    Users Who Are Viewing This Thread (Users: 0, Guests: 1)

    OP Similar threads Forum Replies Date
    M.Hulot After Update 1.25 internal blu-ray-player doesn't work General Support 8
    M.Hulot Interner Blu-ray-Player spielt nach Update auf 1.25 keine Discs mehr ab Allgemeines Supportforum 2
    E retaining Watch Status when updating? Newcomers Forum 1
    J Update .NET framework? Improvement Suggestions 9
    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 [WiP] 5043: Update MP1 to VisualStudio 2019 MediaPortal 1 138
    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
    Similar threads

























    Top Bottom