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.
     
    #1 Nodren, Oct 16, 2006
  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.
     
    #2 tweakservers, Oct 16, 2006
  3. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    774
    Likes Received:
    4
    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
     
    #3 mickalo, Oct 16, 2006
  4. katmai

    katmai Well-Known Member

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

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

    # basedir=/var/lib
     
    #4 katmai, Oct 17, 2006
(You must log in or sign up to post here.)
Loading...
Similar Threads - upgrading mysql
  1. willrijo

    Error upgrading mysql 5.5 to MariaDB 10.1

    willrijo, May 15, 2017, in forum: Database Discussions
    Replies:
    4
    Views:
    111
    rpvw
    May 16, 2017
  2. anseme

    SOLVED Upgrade EasyApache first before upgrading Mysql?

    anseme, Jan 6, 2017, in forum: EasyApache
    Replies:
    2
    Views:
    266
    anseme
    Jan 7, 2017
  3. luigidelgado

    Replication after upgrading MySQL 5.6 to MariaDB

    luigidelgado, Mar 7, 2016, in forum: Database Discussions
    Replies:
    1
    Views:
    518
    cPanelMichael
    Mar 8, 2016
  4. cristis

    Error upgrading MySQL 5.6 to MariaDB 10.1

    cristis, Jan 31, 2016, in forum: Database Discussions
    Replies:
    6
    Views:
    1,257
    cPanelMichael
    Feb 6, 2017
  5. IRZQ88

    Out of RAM after upgrading to Easyapache4

    IRZQ88, May 5, 2017, in forum: EasyApache
    Replies:
    1
    Views:
    90
    Infopro
    May 5, 2017

Share This Page