MP1-4341 Add possibility to Deploy Tool to upgrade MySQL dB

Sebastiii

Development Group
  • Team MediaPortal
  • November 12, 2007
    16,350
    113
    France
    Home Country
    France France
    Country flag
    • Thread starter
    • Moderator
    • #11
    V3 online in first post :)
    1.5.0 should install MySQL 5.1 :)
    1.6.0 Install MySQL 5.6 only on fresh installation.
     

    breese

    Retired Team Member
  • Premium Supporter
  • July 11, 2011
    3,903
    83
    61
    Arlington Heights, Illinois
    Home Country
    United States of America United States of America
    Country flag
    It appears the upgrade works. I have no way of validating the new DB except I removed the left over DB files from the 5.1 install and opened TV-Server Configure..... All my channels were intact

    As for the left over DB info
    As you can see, each of these are screenshots of Both Data folders and what was inside them.
    I don't know if this is what you want to do or not so I am reporting it.
    MySQL_01.jpg MySQL_02.jpg
     

    Sebastiii

    Development Group
  • Team MediaPortal
  • November 12, 2007
    16,350
    113
    France
    Home Country
    France France
    Country flag
    • Thread starter
    • Moderator
    • #13
    Great :) yep the installer perform a backup of 5.1 db -> uninstall 5.1 -> install 5.6 -> restore db.
    5.1 stay on PC in case of something failed :)
    Thanks :)
     

    Sebastiii

    Development Group
  • Team MediaPortal
  • November 12, 2007
    16,350
    113
    France
    Home Country
    France France
    Country flag
    • Thread starter
    • Moderator
    • #15
    Nope, it created only an .sql in temp user folder :)
     

    breese

    Retired Team Member
  • Premium Supporter
  • July 11, 2011
    3,903
    83
    61
    Arlington Heights, Illinois
    Home Country
    United States of America United States of America
    Country flag
    I was just going thru my Application Events log and found this from the time the upgrade was happening

    Error - Incorrect definition of table mysql.proc: expected column 'comment' at position 15 to have type text, found type char(64).
     

    Sebastiii

    Development Group
  • Team MediaPortal
  • November 12, 2007
    16,350
    113
    France
    Home Country
    France France
    Country flag
    • Thread starter
    • Moderator
    • #17
    Seems to solve the issue :
    Code:
    [7 Jan 2011 22:29] Peter Laursen
    
    Will this help:
    http://dev.mysql.com/doc/refman/5.5/en/news-5-5-7.html
    
    "start the server with the --skip-grant-tables option to cause it to skip the normal grant table checks, then run mysql_upgrade. ... Then stop the server and restart it normally."
    
    Peter
    (not a MySQL person)
    So maybe add this '--skip-grant-tables' when restore but i'm not sure.
     

    pur_berger

    Super User
  • Team MediaPortal
  • Super User
  • May 14, 2007
    1,679
    83
    47
    Vienna
    Home Country
    Austria Austria
    Country flag
    Just tried your Setup - steps taken - installed MP 1.5 final (had 1.6 on teh machine before) - run your Setup - installation went straight throw without any issues. Also my rather big JMMServer was migrated to 5.6 (Japanese Media Manager). The only thing i Noticed is that the first install dialog appears two times.
     

    Sebastiii

    Development Group
  • Team MediaPortal
  • November 12, 2007
    16,350
    113
    France
    Home Country
    France France
    Country flag
    • Thread starter
    • Moderator
    • #19
    I was just going thru my Application Events log and found this from the time the upgrade was happening

    Error - Incorrect definition of table mysql.proc: expected column 'comment' at position 15 to have type text, found type char(64).
    Hi,

    I have spend all the morning to try to add '--skip-grant-tables', it's tricky because we need to start mysqld.exe (not the service) -> start mysql upgrade etc. -> kill mysqld.exe -> start the service etc.

    But in final lol, '--skip-grant-tables' didn't work and in fact the restore/upgrade works :)

    Code:
    Looking for 'mysql.exe' as: C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe
    Looking for 'mysqlcheck.exe' as: C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqlcheck.exe
    Running 'mysqlcheck' with connection arguments: "--port=3306" "--port=3306" "--host=localhost"
    Running 'mysqlcheck' with connection arguments: "--port=3306" "--port=3306" "--host=localhost"
    mptvdb.canceledschedule                            OK
    mptvdb.card                                        OK
    mptvdb.cardgroup                                   OK
    mptvdb.cardgroupmap                                OK
    mptvdb.channel                                     OK
    mptvdb.channelgroup                                OK
    mptvdb.channellinkagemap                           OK
    mptvdb.channelmap                                  OK
    mptvdb.conflict                                    OK
    mptvdb.diseqcmotor                                 OK
    mptvdb.favorite                                    OK
    mptvdb.groupmap                                    OK
    mptvdb.history                                     OK
    mptvdb.keyword                                     OK
    mptvdb.keywordmap                                  OK
    mptvdb.pendingdeletion                             OK
    mptvdb.personaltvguidemap                          OK
    mptvdb.program                                     OK
    mptvdb.radiochannelgroup                           OK
    mptvdb.radiogroupmap                               OK
    mptvdb.recording                                   OK
    mptvdb.satellite                                   OK
    mptvdb.schedule                                    OK
    mptvdb.server                                      OK
    mptvdb.setting                                     OK
    mptvdb.softwareencoder                             OK
    mptvdb.timespan                                    OK
    mptvdb.tuningdetail                                OK
    mptvdb.tvmoviemapping                              OK
    mptvdb.version                                     OK
    mysql.columns_priv                                 OK
    mysql.db                                           OK
    mysql.event                                        OK
    mysql.func                                         OK
    mysql.general_log                                  OK
    mysql.help_category                                OK
    mysql.help_keyword                                 OK
    mysql.help_relation                                OK
    mysql.help_topic                                   OK
    mysql.host                                         OK
    mysql.innodb_index_stats                           OK
    mysql.innodb_table_stats                           OK
    mysql.ndb_binlog_index                             OK
    mysql.plugin                                       OK
    mysql.proc                                         OK
    mysql.procs_priv                                   OK
    mysql.proxies_priv                                 OK
    mysql.servers                                      OK
    mysql.slave_master_info                            OK
    mysql.slave_relay_log_info                         OK
    mysql.slave_worker_info                            OK
    mysql.slow_log                                     OK
    mysql.tables_priv                                  OK
    mysql.time_zone                                    OK
    mysql.time_zone_leap_second                        OK
    mysql.time_zone_name                               OK
    mysql.time_zone_transition                         OK
    mysql.time_zone_transition_type                    OK
    mysql.user                                         OK
    Running 'mysql_fix_privilege_tables'...
    OK
    Like we can see : mysql.proc is OK :)
    So we don't have to care about it :p

    So we are good :)
     

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

    Top Bottom