MP1-4341 Add possibility to Deploy Tool to upgrade MySQL dB | Page 2

Discussion in 'Area 51 - Testing Area' started by Sebastiii, January 24, 2014.

  1. Sebastiii
    • Team MediaPortal

    Sebastiii Development Group

    Joined:
    November 12, 2007
    Messages:
    16,237
    Likes Received:
    6,201
    Gender:
    Male
    Location:
    France
    Ratings:
    +10,199 / 9
    Home Country:
    France France
    Show System Specs
    V3 online in first post :)
    1.5.0 should install MySQL 5.1 :)
    1.6.0 Install MySQL 5.6 only on fresh installation.


     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. breese
    • Team MediaPortal

    breese Retired Team Member

    Joined:
    July 11, 2011
    Messages:
    3,903
    Likes Received:
    325
    Gender:
    Male
    Occupation:
    Sr. Systems Engineer
    Location:
    Arlington Heights, Illinois
    Ratings:
    +768 / 0
    Home Country:
    United States of America United States of America
    Show System Specs
    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
     
    • Thank You! Thank You! x 1
  4. Sebastiii
    • Team MediaPortal

    Sebastiii Development Group

    Joined:
    November 12, 2007
    Messages:
    16,237
    Likes Received:
    6,201
    Gender:
    Male
    Location:
    France
    Ratings:
    +10,199 / 9
    Home Country:
    France France
    Show System Specs
    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 :)
     
  5. breese
    • Team MediaPortal

    breese Retired Team Member

    Joined:
    July 11, 2011
    Messages:
    3,903
    Likes Received:
    325
    Gender:
    Male
    Occupation:
    Sr. Systems Engineer
    Location:
    Arlington Heights, Illinois
    Ratings:
    +768 / 0
    Home Country:
    United States of America United States of America
    Show System Specs
    Does the DB upgrade write a log or can it? I could not locate one
     
    • Like Like x 1
  6. Sebastiii
    • Team MediaPortal

    Sebastiii Development Group

    Joined:
    November 12, 2007
    Messages:
    16,237
    Likes Received:
    6,201
    Gender:
    Male
    Location:
    France
    Ratings:
    +10,199 / 9
    Home Country:
    France France
    Show System Specs
    Nope, it created only an .sql in temp user folder :)
     
  7. breese
    • Team MediaPortal

    breese Retired Team Member

    Joined:
    July 11, 2011
    Messages:
    3,903
    Likes Received:
    325
    Gender:
    Male
    Occupation:
    Sr. Systems Engineer
    Location:
    Arlington Heights, Illinois
    Ratings:
    +768 / 0
    Home Country:
    United States of America United States of America
    Show System Specs
    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).
     
    • Thank You! Thank You! x 1
  8. Sebastiii
    • Team MediaPortal

    Sebastiii Development Group

    Joined:
    November 12, 2007
    Messages:
    16,237
    Likes Received:
    6,201
    Gender:
    Male
    Location:
    France
    Ratings:
    +10,199 / 9
    Home Country:
    France France
    Show System Specs
    Seems to solve the issue :
    Code (Text):
    1.  
    2. [7 Jan 2011 22:29] Peter Laursen
    3.  
    4. Will this help:
    5. http://dev.mysql.com/doc/refman/5.5/en/news-5-5-7.html
    6.  
    7. "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."
    8.  
    9. Peter
    10. (not a MySQL person)
    11.  
    So maybe add this '--skip-grant-tables' when restore but i'm not sure.
     
  9. pur_berger
    • Super User

    pur_berger Super User

    Joined:
    May 14, 2007
    Messages:
    1,678
    Likes Received:
    183
    Gender:
    Male
    Location:
    Vienna
    Ratings:
    +270 / 1
    Home Country:
    Austria Austria
    Show System Specs
    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.
     
    • Thank You! Thank You! x 1
  10. Sebastiii
    • Team MediaPortal

    Sebastiii Development Group

    Joined:
    November 12, 2007
    Messages:
    16,237
    Likes Received:
    6,201
    Gender:
    Male
    Location:
    France
    Ratings:
    +10,199 / 9
    Home Country:
    France France
    Show System Specs
    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 (Text):
    1. Looking for 'mysql.exe' as: C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe
    2. Looking for 'mysqlcheck.exe' as: C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqlcheck.exe
    3. Running 'mysqlcheck' with connection arguments: "--port=3306" "--port=3306" "--host=localhost"
    4. Running 'mysqlcheck' with connection arguments: "--port=3306" "--port=3306" "--host=localhost"
    5. mptvdb.canceledschedule                            OK
    6. mptvdb.card                                        OK
    7. mptvdb.cardgroup                                   OK
    8. mptvdb.cardgroupmap                                OK
    9. mptvdb.channel                                     OK
    10. mptvdb.channelgroup                                OK
    11. mptvdb.channellinkagemap                           OK
    12. mptvdb.channelmap                                  OK
    13. mptvdb.conflict                                    OK
    14. mptvdb.diseqcmotor                                 OK
    15. mptvdb.favorite                                    OK
    16. mptvdb.groupmap                                    OK
    17. mptvdb.history                                     OK
    18. mptvdb.keyword                                     OK
    19. mptvdb.keywordmap                                  OK
    20. mptvdb.pendingdeletion                             OK
    21. mptvdb.personaltvguidemap                          OK
    22. mptvdb.program                                     OK
    23. mptvdb.radiochannelgroup                           OK
    24. mptvdb.radiogroupmap                               OK
    25. mptvdb.recording                                   OK
    26. mptvdb.satellite                                   OK
    27. mptvdb.schedule                                    OK
    28. mptvdb.server                                      OK
    29. mptvdb.setting                                     OK
    30. mptvdb.softwareencoder                             OK
    31. mptvdb.timespan                                    OK
    32. mptvdb.tuningdetail                                OK
    33. mptvdb.tvmoviemapping                              OK
    34. mptvdb.version                                     OK
    35. mysql.columns_priv                                 OK
    36. mysql.db                                           OK
    37. mysql.event                                        OK
    38. mysql.func                                         OK
    39. mysql.general_log                                  OK
    40. mysql.help_category                                OK
    41. mysql.help_keyword                                 OK
    42. mysql.help_relation                                OK
    43. mysql.help_topic                                   OK
    44. mysql.host                                         OK
    45. mysql.innodb_index_stats                           OK
    46. mysql.innodb_table_stats                           OK
    47. mysql.ndb_binlog_index                             OK
    48. mysql.plugin                                       OK
    49. mysql.proc                                         OK
    50. mysql.procs_priv                                   OK
    51. mysql.proxies_priv                                 OK
    52. mysql.servers                                      OK
    53. mysql.slave_master_info                            OK
    54. mysql.slave_relay_log_info                         OK
    55. mysql.slave_worker_info                            OK
    56. mysql.slow_log                                     OK
    57. mysql.tables_priv                                  OK
    58. mysql.time_zone                                    OK
    59. mysql.time_zone_leap_second                        OK
    60. mysql.time_zone_name                               OK
    61. mysql.time_zone_transition                         OK
    62. mysql.time_zone_transition_type                    OK
    63. mysql.user                                         OK
    64. Running 'mysql_fix_privilege_tables'...
    65. OK
    66.  
    Like we can see : mysql.proc is OK :)
    So we don't have to care about it :p

    So we are good :)
     
    • Like Like x 1
  11. Sebastiii
    • Team MediaPortal

    Sebastiii Development Group

    Joined:
    November 12, 2007
    Messages:
    16,237
    Likes Received:
    6,201
    Gender:
    Male
    Location:
    France
    Ratings:
    +10,199 / 9
    Home Country:
    France France
    Show System Specs
    V4 online :)
     
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!