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.

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:
    1
    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:
    16
    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.
     
  3. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    765
    Likes Received:
    2
    Trophy Points:
    18
    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
     
  4. katmai

    katmai Well-Known Member

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

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

    # basedir=/var/lib
     
Loading...

Share This Page