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!

Manually upgrading MySQL 5.0

Discussion in 'General Discussion' started by testlog_4u, Sep 7, 2009.

  1. testlog_4u

    testlog_4u Active Member

    Joined:
    Sep 17, 2007
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    56
    In cpanel server is there any easy way to update mysql 5.0.81 to 5.0.84?

    Thanks in advance..
     
    #1 testlog_4u, Sep 7, 2009
  2. testlog_4u

    testlog_4u Active Member

    Joined:
    Sep 17, 2007
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    56
    Its done I think :D

    Okay, I sorted out it. I had to upgrade following RPM's by downloading those from any RPM providers from net.

    root@server [~]# rpm -qa |grep -i mysql
    MySQL-shared-5.0.84-0.glibc23
    MySQL-bench-5.0.84-0.glibc23
    MySQL-devel-5.0.84-0.glibc23
    MySQL-server-5.0.84-0.glibc23
    MySQL-client-5.0.84-0.glibc23

    I got a lot of PERL module dependencies and none of them were installed through cpan or WHM>>Install Perl Module and /scripts/perlinstaller.

    I had to install all of the perl module dependencies from RPM sources.

    Like:
    #wget ftp://fr2.rpmfind.net/linux/epel/4/i386/perl-Net-Daemon-0.44-7.el4.noarch.rpm
    --19:38:09-- ftp://fr2.rpmfind.net/linux/epel/4/i386/perl-Net-Daemon-0.44-7.el4.noarch.rpm

    #rpm -Uvh perl-Net-Daemon-0.44-7.el4.noarch.rpm

    #rpm -Uvh ftp://ftp.freshrpms.net/pub/freshrpms/pub/dag/redhat/el5/en/x86_64/dag/RPMS/perl-PlRPC-0.2020-1.el5.rf.noarch.rpm

    and then I downloaded these RPM's and installed them by rpm -Uvh:

    MySQL-bench-5.0.84-0.glibc23.x86_64.rpm
    MySQL-client-5.0.84-0.glibc23.x86_64.rpm
    MySQL-devel-5.0.84-0.glibc23.x86_64.rpm
    MySQL-server-5.0.84-0.glibc23.x86_64.rpm
    MySQL-shared-5.0.84-0.glibc23.x86_64.rpm

    Don't use '--nodeps' option.

    and now it is working fine :)

    root@server [~]# mysql -V
    mysql Ver 14.12 Distrib 5.0.84, for unknown-linux-gnu (x86_64) using readline 5.1
    root@server [~]# mysql
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 3547
    Server version: 5.0.84-community MySQL Community Edition (GPL)

    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

    mysql>

    ----------------

    How was it?
     
    #2 testlog_4u, Sep 7, 2009
  3. whplus

    whplus Well-Known Member

    Joined:
    Dec 8, 2007
    Messages:
    72
    Likes Received:
    1
    Trophy Points:
    58
    Location:
    Behind your business
    There is MySQL 5.0.85 in EDGE version as seen on http://changelog.cpanel.net.
    You can, at your own risk, change update preference to EDGE and run /scripts/mysqlup from shell.

    susan,
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 whplus, Sep 7, 2009
    Last edited: Sep 7, 2009
  4. testlog_4u

    testlog_4u Active Member

    Joined:
    Sep 17, 2007
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    56
    Hello Susan,

    What do you think what is the difference between stable, release and Edge?

    thanks for the reply..
     
    #4 testlog_4u, Sep 8, 2009
  5. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,563
    Likes Received:
    43
    Trophy Points:
    308
    cPanel Access Level:
    Root Administrator
    * * * These posts had nothing to do with MySQL 5.1. * * * *

    To testlog_4u: you can find information on the cPanel product branches elsewhere on the forum or our documentation.

    EDGE is not recommended for production servers. EDGE is the equivalent of public beta and should only be run by experienced system administrators. You can expect things to break spectacularly on EDGE.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 cPanelKenneth, Sep 8, 2009
(You must log in or sign up to post here.)
Loading...
Similar Threads - Manually upgrading MySQL
  1. rfc001

    Configure Web Disk Manually using IP

    rfc001, Sep 17, 2018, in forum: General Discussion
    Replies:
    6
    Views:
    97
    rfc001
    Sep 18, 2018
  2. marjwyatt

    Increase in clamd failures after manually updating

    marjwyatt, Sep 17, 2018, in forum: General Discussion
    Replies:
    20
    Views:
    252
    adamreece.webbox
    Oct 12, 2018 at 7:14 AM
  3. postcd

    How to manually downgrade from WHM v. 74?

    postcd, Aug 16, 2018, in forum: General Discussion
    Replies:
    8
    Views:
    237
    postcd
    Aug 24, 2018
  4. planetjoin

    Move from MySQL 5.7 to MariaDB 10.0.34 manually?

    planetjoin, Aug 11, 2018, in forum: Database Discussion
    Replies:
    7
    Views:
    304
    cPanelMichael
    Aug 23, 2018
  5. mbay2002

    accounts created manually in shell, how to get into cPanel?

    mbay2002, May 14, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    149
    cPanelMichael
    May 14, 2018

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