Manually upgrading MySQL 5.0

[testlog_4u]

In cpanel server is there any easy way to update mysql 5.0.81 to 5.0.84?

Thanks in advance..

 

[testlog_4u]

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.

[email protected] [~]# 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

[email protected] [~]# mysql -V
mysql Ver 14.12 Distrib 5.0.84, for unknown-linux-gnu (x86_64) using readline 5.1
[email protected] [~]# 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?

 

[whplus]

In cpanel server is there any easy way to update mysql 5.0.81 to 5.0.84?

Thanks in advance..

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,

 

[testlog_4u]

Hello Susan,

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

thanks for the reply..

 

[cPanelKenneth]

* * * 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.