Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

upgrading to mysql 5

Discussion in 'General Discussion' started by Nodren, Oct 16, 2006.

  1. Nodren

    Nodren Registered

    Joined:
    Oct 24, 2005
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    151
    We are looking into upgrading to mysql 5 on our CentOS servers, I was wondering if there was any offical cpanel way of doing this, or if i should just follow a general linux howto?

    also, is mysql 5.0 and mysql 5.1 production ready?

    thanks.
     
  2. tweakservers

    tweakservers Well-Known Member

    Joined:
    Mar 30, 2006
    Messages:
    379
    Likes Received:
    0
    Trophy Points:
    166
    go into your WHM > TweakSettings and select the MySQL 5 > Save it

    login as root via SSH and run /scripts/mysqlup, it will do the upgrade for you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    778
    Likes Received:
    4
    Trophy Points:
    318
    Location:
    N.W. Iowa
    we did that earlier today and can not get MySQL restarted now, keep getting the following error:
    Code:
    Starting MySQLCouldn't find MySQL manager or server
    
    ran easyapache again, still no luck getting mysql restarted now. any suggestion on how to get MySQL going again?? We were running 4.1.21 before with no problems. These are the RPM's installed now after the upgrade:
    Code:
    MySQL-embedded-4.1.21-0.glibc23
    MySQL-shared-5.0.24-0.glibc23
    MySQL-server-5.0.24-0.glibc23
    MySQL-devel-5.0.24-0.glibc23
    MySQL-bench-5.0.24-0.glibc23
    MySQL-client-5.0.24-0.glibc23
    
    so it appears everything is there.

    Mickalo
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. katmai

    katmai Well-Known Member

    Joined:
    Mar 13, 2006
    Messages:
    533
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Brno, Czech Republic
    /etc/my.cnf

    comment out the line ... restart mysql. all up

    # basedir=/var/lib
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  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