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.

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:
    6
    In cpanel server is there any easy way to update mysql 5.0.81 to 5.0.84?

    Thanks in advance..
     
  2. testlog_4u

    testlog_4u Active Member

    Joined:
    Sep 17, 2007
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    6
    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/freshrp...ag/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?
     
  3. whplus

    whplus Well-Known Member

    Joined:
    Dec 8, 2007
    Messages:
    66
    Likes Received:
    1
    Trophy Points:
    8
    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,
     
    #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:
    6
    Hello Susan,

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

    thanks for the reply..
     
  5. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,461
    Likes Received:
    22
    Trophy Points:
    38
    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.
     
Loading...

Share This Page