The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Upgraded to MySQL v5.1.30

Discussion in 'General Discussion' started by AndyReed, Dec 7, 2008.

  1. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    Just want to share this with the community. I upgraded MySQL to v5.1.30 on a VPS and a dedicated server and found the new MySQL works just fine.
     
  2. whplus

    whplus Well-Known Member

    Joined:
    Dec 8, 2007
    Messages:
    66
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    Behind your business
    Would you like to share with us how do you upgrade your MySQL to v5.1.30?

    Susan,
     
  3. ANewDay

    ANewDay Well-Known Member

    Joined:
    Sep 11, 2006
    Messages:
    86
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    USA
    Yes, how do you upgrade from 4.1.22 to the newest 5?
     
  4. mvdig

    mvdig Registered

    Joined:
    Jun 20, 2007
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    but my hosting company tell me MySQL 5.1.30 is not supported cPanel
     
  5. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Correct, MySQL 5.1 is not officially supported by cPanel/WHM at this time.
     
  6. ANewDay

    ANewDay Well-Known Member

    Joined:
    Sep 11, 2006
    Messages:
    86
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    USA
    Any timeframe when it will be supported?
     
  7. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    Although MySQL v5.1.30 is not yet supported by the cPanel, we tried it and it works just fine.
     
  8. ANewDay

    ANewDay Well-Known Member

    Joined:
    Sep 11, 2006
    Messages:
    86
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    USA
    Ok, I may give it a try. How do you upgrade it painlessly?
     
  9. Devilfish

    Devilfish Member

    Joined:
    Dec 7, 2008
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    This is the information I was looking for, thanks.

    Is there an official page with the latest versions of software that's available with cpanel?

    I currently have a management service for my server but want to manage myself soon so I would also be interested in knowing how to upgrade!

    Thanks for any info! :)
     
  10. icomunik

    icomunik Member

    Joined:
    Jul 18, 2008
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    We NEED mySQL Upgrade on CPANEL ASAP

    I am also looking for step by step how to upgrade mySQL from 5.067 to 5.1. Unfortunately it seems that cPanel is not in a hurry to offer an upgrade.

    If someone can point us in the right direction I appreciate.


    Cheers
     
  11. whplus

    whplus Well-Known Member

    Joined:
    Dec 8, 2007
    Messages:
    66
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    Behind your business
    I see on http://httpupdate.cpanel.net/mysqlinstall/version
    susan,
     
  12. Devilfish

    Devilfish Member

    Joined:
    Dec 7, 2008
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    I'm new to upgrading my server, I usually pay a server management company to do it but I want to try and learn myself.

    How can I upgrade from MySQl 4.0.67 community to 5.1.30?

    Server:
    cPanel 11.24.4-R33311 - WHM 11.24.2 - X 3.9
    CENTOS 5.2 x86_64 on standard

    Thanks for any help! :)
     
  13. InterServed

    InterServed Well-Known Member

    Joined:
    Jul 10, 2007
    Messages:
    255
    Likes Received:
    2
    Trophy Points:
    18
    cPanel Access Level:
    DataCenter Provider
    Most probably they will push a new select option from WHM:
    MySQL : 4.x ; 5.0.x ; 5.1.x

    I think you can upgrade with cPanel scripts ( tho i may be wrong, have not tested ! ):
    edit /var/cpanel/cpanel.config and set mysql-version=5.1 then execute /scripts/mysqlup
     
    #13 InterServed, Jan 19, 2009
    Last edited: Jan 19, 2009
  14. Devilfish

    Devilfish Member

    Joined:
    Dec 7, 2008
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    I think I have done this ok...thank you!

    I had to run EasyApache (Apache Update) after the upgrade. had an error when restarting httpd, something about php, all ok after reconfiguring php.

    Anything else I need to do please?

    Now running MySQL 5.1.30 and PHP 5.2.8.

    Thank you! :)
     
  15. icomunik

    icomunik Member

    Joined:
    Jul 18, 2008
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    It worked, thank you so much
     
  16. InterServed

    InterServed Well-Known Member

    Joined:
    Jul 10, 2007
    Messages:
    255
    Likes Received:
    2
    Trophy Points:
    18
    cPanel Access Level:
    DataCenter Provider
    Please be aware that I am not responsible for any issues/damage , 5.1.30 is not officially supported to cPanel at this time(from what i can see at least i believe it was uploaded just for internal testing purposes).

    So, upgrade at your own risk.
     
  17. icomunik

    icomunik Member

    Joined:
    Jul 18, 2008
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    Don't worry!! The upgrade worked fine and everything is running 100%. Actually all my sites that run under mySQL is now much faster and more responsive. 5.1 is the way to go.
     
  18. Kurieuo

    Kurieuo Well-Known Member

    Joined:
    Dec 13, 2002
    Messages:
    98
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Australia
    Just a word of warning - do it late at night when few users would being using their websites.

    I did it during the day and Apache did not work properly, and I had to wait until a second recompile was finished for it to come back to life (the first recompile failed!).
     
  19. drsinger111

    drsinger111 Member

    Joined:
    Feb 21, 2008
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    also working cent 4.4

    Code:
    vim /var/cpanel/cpanel.config
    and set mysql-version=5.1
    then execute
    Code:
    /scripts/mysqlup
    then run ea to reset the new install
    Code:
    /scripts/easyapache
    then run
    Code:
    /scripts/perlinstaller --force Bundle::DBD::mysql
    after the install you may receive an error similar to the following:
    ERROR! MySQL manager or server PID file could not be found!
    solved: This error is caused by the my.cnf file that comes from mysql4 or an earlier version. To correct the error, enter the following commands:

    #
    Code:
    mv my.cnf my.cnf.old
    #
    Code:
     /etc/init.d/mysql start 
    Starting MySQL
    SUCCESS!
     
    #19 drsinger111, Feb 15, 2009
    Last edited: Feb 15, 2009
  20. icomunik

    icomunik Member

    Joined:
    Jul 18, 2008
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    CPanel Bug

    Be careful when you force the upgrade. There is bug in CPanel/WHM that will break your system when you try to update WHM/Cpanel in the control panel.

    I had mysql 5.1.3 running fine, then i tried to upgrade Cpanel to a more up to date release version and it broke everything. CPanel tried to downgrade mySQL to version 4.1 and nothing worked to the point where I need a OS reload.

    So, after upgrading mySQL make sure you turn off any future mySQL upgrade to avoid that.

    At the meantime, CPanel should work on this problem and release a new version where the upgrade is available without forcing anything.
     
Loading...

Share This Page