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:
    68
    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:
    42
    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. postcd

    How to manually downgrade from WHM v. 74?

    postcd, Aug 16, 2018 at 9:54 AM, in forum: General Discussion
    Replies:
    7
    Views:
    107
    Tarak Nath
    Aug 17, 2018 at 4:16 AM
  2. planetjoin

    From mysql 5.7 to MariaDB 10.0.34 manually

    planetjoin, Aug 11, 2018, in forum: Database Discussion
    Replies:
    5
    Views:
    109
    cPanelMichael
    Aug 16, 2018 at 10:26 AM
  3. mbay2002

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

    mbay2002, May 14, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    109
    cPanelMichael
    May 14, 2018
  4. cPanelResources

    Tutorial How to manually migrate from Plesk, Ensim, or DirectAdmin

    cPanelResources, May 10, 2018, in forum: Migrate to cPanel
    Replies:
    0
    Views:
    266
    cPanelResources
    May 10, 2018
  5. surroundsound

    Restoring accounts manually to new system?

    surroundsound, May 8, 2018, in forum: Data Protection
    Replies:
    2
    Views:
    118
    cPanelLauren
    May 8, 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