Update MySQL 5.1 to latest 5.6 version | Page 20

Discussion in 'Area 51 - Testing Area' started by Sebastiii, April 15, 2013.

Page 20 of 22
  1. Sebastiii
    • Team MediaPortal

    Sebastiii Development Group

    Joined:
    November 12, 2007
    Messages:
    16,295
    Likes Received:
    6,247
    Gender:
    Male
    Location:
    France
    Ratings:
    +10,268 / 9
    Home Country:
    France France
    Show System Specs
    January 1, 2014 #191
    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).


     
    Sebastiii, January 1, 2014
    • Great Idea! Great Idea! x 1

  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. D3ltoroxp
    • Premium Supporter

    D3ltoroxp MP Donator

    Joined:
    June 1, 2008
    Messages:
    3,308
    Likes Received:
    133
    Gender:
    Male
    Ratings:
    +207 / 9
    Home Country:
    Germany Germany
    Show System Specs
    January 1, 2014 #192
    And how Change the old db in the new one ? Export Import ? or is this done by your Setup?
     
    D3ltoroxp, January 1, 2014
  4. elliottmc
    • Premium Supporter

    elliottmc Retired Team Member

    Joined:
    August 7, 2005
    Messages:
    14,927
    Likes Received:
    4,011
    Gender:
    Male
    Location:
    Cardiff, UK
    Ratings:
    +5,503 / 13
    Home Country:
    United Kingdom United Kingdom
    Show System Specs
    January 1, 2014 #193
    All done automatically as far as I know.
     
    elliottmc, January 1, 2014
    • Agree Agree x 1
  5. Sebastiii
    • Team MediaPortal

    Sebastiii Development Group

    Joined:
    November 12, 2007
    Messages:
    16,295
    Likes Received:
    6,247
    Gender:
    Male
    Location:
    France
    Ratings:
    +10,268 / 9
    Home Country:
    France France
    Show System Specs
    January 1, 2014 #194
    You can always try to export :) (to have another backup)
     
    Sebastiii, January 1, 2014
  6. D3ltoroxp
    • Premium Supporter

    D3ltoroxp MP Donator

    Joined:
    June 1, 2008
    Messages:
    3,308
    Likes Received:
    133
    Gender:
    Male
    Ratings:
    +207 / 9
    Home Country:
    Germany Germany
    Show System Specs
    January 1, 2014 #195
    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.
     

    Attached Files:

    • mysql 5.6.PNG
      mysql 5.6.PNG
      File size:
      37.1 KB
      Uploaded:
      January 1, 2014
      Views:
      150
    D3ltoroxp, January 1, 2014
    • Like Like x 1
  7. netexplorer
    • Premium Supporter

    netexplorer MP Donator

    Joined:
    January 21, 2009
    Messages:
    727
    Likes Received:
    69
    Ratings:
    +101 / 1
    Home Country:
    Germany Germany
    Show System Specs
    January 2, 2014 #196
    Are you shure your tables are in InnoDB format? Have checked this with Workbench?
     
    netexplorer, January 2, 2014
  8. Hawkeye

    Hawkeye Portal Pro

    Joined:
    January 29, 2005
    Messages:
    548
    Likes Received:
    60
    Gender:
    Male
    Occupation:
    digital media designer
    Location:
    Halle (Saale)
    Ratings:
    +89 / 1
    Home Country:
    Germany Germany
    Show System Specs
    January 2, 2014 #197
    Just done the upgrade this way yesterday and all worked like a charm ...
     
    Hawkeye, January 2, 2014
  9. D3ltoroxp
    • Premium Supporter

    D3ltoroxp MP Donator

    Joined:
    June 1, 2008
    Messages:
    3,308
    Likes Received:
    133
    Gender:
    Male
    Ratings:
    +207 / 9
    Home Country:
    Germany Germany
    Show System Specs
    January 2, 2014 #198
    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 ?
     
    D3ltoroxp, January 2, 2014
  10. Hawkeye

    Hawkeye Portal Pro

    Joined:
    January 29, 2005
    Messages:
    548
    Likes Received:
    60
    Gender:
    Male
    Occupation:
    digital media designer
    Location:
    Halle (Saale)
    Ratings:
    +89 / 1
    Home Country:
    Germany Germany
    Show System Specs
    January 2, 2014 #199
    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 (Text):
    1. SELECT `TABLE_NAME`, `ENGINE` FROM `information_schema`.`TABLES` WHERE `TABLE_SCHEMA` = 'mptvdb';
     
    Last edited: January 2, 2014
    Hawkeye, January 2, 2014
  11. regeszter
    • Premium Supporter

    regeszter Retired Team Member

    Joined:
    October 29, 2005
    Messages:
    5,335
    Likes Received:
    2,863
    Ratings:
    +5,152 / 18
    Home Country:
    Hungary Hungary
    January 2, 2014 #200
    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
     
    regeszter, January 2, 2014
    • Like Like x 3
Page 20 of 22
Loading...
Similar Threads - Update MySQL latest
  1. Olli123

    How to Update MP1.5 to MP1.6 with using the new MySQL 5.6 engine?

    Olli123, January 7, 2014, in forum: General Support
    Replies:
    1
    Views:
    617
    Iwen
    January 7, 2014
  2. D3ltoroxp

    Nach Update auf 1.6 und mySqL 5.6 hängt mp nach Standby

    D3ltoroxp, January 2, 2014, in forum: Allgemeines Supportforum
    Replies:
    8
    Views:
    1,307
    Holzi
    August 4, 2014
  3. MediaPortal-Bot

    MediaPortal 2 0004408: Update MySQL references and remove binaries from git repo (NuGet)

    MediaPortal-Bot, April 30, 2013, in forum: Bugtracker Feed
    Replies:
    0
    Views:
    453
    MediaPortal-Bot
    April 30, 2013
  4. azzuro

    [How To] [User Exp] Update MySQL

    azzuro, January 26, 2013, in forum: Tools and other software
    Replies:
    67
    Views:
    15,401
    Sebastiii
    March 9, 2014
  5. Coranth

    Update MySQL

    Coranth, November 24, 2012, in forum: MediaPortal 1 Talk
    Replies:
    0
    Views:
    691
    Coranth
    November 24, 2012

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.
    Accept Learn More...
    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.

             

  • Quick Navigation

  • 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!