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.
     
    #1 Nodren, Oct 16, 2006
  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...
    #2 tweakservers, Oct 16, 2006
  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...
    #3 mickalo, Oct 16, 2006
  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...
    #4 katmai, Oct 17, 2006
(You must log in or sign up to post here.)
Loading...
Similar Threads - upgrading mysql
  1. keat63

    Upgrading MySQL 5.6 to MariaDB 10.2 Question

    keat63, May 17, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    574
    cPanelMichael
    May 18, 2018
  2. Sayem

    Activate MySQL 5.7 after upgrading to v70.0.12

    Sayem, Feb 16, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    724
    cPanelMichael
    Feb 19, 2018
  3. Venomous21

    Upgrading to MySQL 5.7

    Venomous21, Jan 30, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    2,418
    cPanelMichael
    Jan 31, 2018
  4. willrijo

    Error upgrading mysql 5.5 to MariaDB 10.1

    willrijo, May 15, 2017, in forum: Database Discussion
    Replies:
    4
    Views:
    1,156
    rpvw
    May 16, 2017
  5. anseme

    SOLVED Upgrade EasyApache first before upgrading Mysql?

    anseme, Jan 6, 2017, in forum: EasyApache
    Replies:
    2
    Views:
    927
    anseme
    Jan 7, 2017

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.
    Accept Learn More...
    Dismiss Notice