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.

upgrade mysql

Discussion in 'General Discussion' started by tiff2342, May 13, 2012.

  1. tiff2342

    tiff2342 Well-Known Member

    Joined:
    Apr 20, 2012
    Messages:
    140
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    can i use whm to upgrade mysql from 5.1 to 5.5?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,696
    Likes Received:
    656
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Yes, you can utilize the following option in Web Host Manager to upgrade to MySQL 5.5:

    "WHM >> Software >> MySQL Upgrade"

    Thank you.
     
  3. tiff2342

    tiff2342 Well-Known Member

    Joined:
    Apr 20, 2012
    Messages:
    140
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    would it cause any problems?
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,696
    Likes Received:
    656
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Upgrading MySQL should not result in any problems with MySQL running, however it's a good idea to ensure your scripts are compatible with MySQL 5.5 before upgrading. The "MySQL Upgrade" option will also list any potential issues with the MySQL upgrade itself.

    Thank you.
     
  5. gkgcpanel

    gkgcpanel Well-Known Member

    Joined:
    Jun 6, 2007
    Messages:
    217
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    DataCenter Provider
    is there anyway to deterimine if the mysql upgrade (run via whm) seems to be stuck???
     
  6. pwhjenny

    pwhjenny Well-Known Member

    Joined:
    Aug 31, 2012
    Messages:
    135
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    You can check progress bar in the browser if it stays at single point then most likely its stuck. If your network is unstable, you can try using scree via ssh.
     
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,696
    Likes Received:
    656
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Access the server via SSH and look for "mysqlup" in the process list. EX:

    Code:
    # ps auxf
    Thank you.
     
  8. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Hello,

    I wanted to point out this post by cpanelkenneth:

    http://forums.cpanel.net/f354/where...ql-upgrades-log-files-278342.html#post1239711

    This lets you know the location of the MySQL upgrade logs when using WHM GUI for it. This should help to see if the process appears to be stuck as well.

    If you do see mysql up in the ps aux:

    Code:
    ps aux | grep mysqlup
    Then note the PID number and then run an lsof on it to see what it's doing:

    Code:
    lsof -p PID#
    Please replace PID# with the process ID number of the mysqlup process.

    Thanks!
     
Loading...

Share This Page