Upgrading mySQL.

[strago]

So, I tried upgrading mySQL and PHP using up2date and what did it do? Downgraded me from mySQL 4.0.26-standard to 3.23.58 and did nothing with PHP.

 

Is there a n00bie guide some where for *upgrading* php and mySQL?

 

PHP Version 4.4.4

MySQL 4.0.26-standard and now downgraded to 3.23.58

Ensim Basic 4.0.3-22.rhel.3ES

 

I try to upgrade back to where I was at and I get...

 

[root@mail admin]# rpm -Uvh --nodeps MySQL*.rpm
warning: MySQL-client-4.0.26-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
package MySQL-shared-compat-4.0.26-0 is already installed
package MySQL-devel-4.0.26-0 is already installed
package MySQL-shared-4.0.26-0 is already installed

 

so I try upgrading and get

 

[root@mail admin]# rpm -Uvh --nodeps MySQL*-5.0.89-0.i386.rpm
error: MySQL-client-5.0.89-0.i386.rpm: rpmReadSignature failed: region trailer: BAD, tag 61 type 7 offset 48 count 16
error: MySQL-client-5.0.89-0.i386.rpm cannot be installed
error: MySQL-devel-5.0.89-0.i386.rpm: rpmReadSignature failed: region trailer: BAD, tag 61 type 7 offset 48 count 16
error: MySQL-devel-5.0.89-0.i386.rpm cannot be installed
error: MySQL-server-5.0.89-0.i386.rpm: rpmReadSignature failed: region trailer: BAD, tag 61 type 7 offset 48 count 16
error: MySQL-server-5.0.89-0.i386.rpm cannot be installed

 

How do you upgrade mySQL and get it to work? Does any one know which URLs at

 

ftp://mysql.secsup.org/pub/software/mysql/Downloads/MySQL-5.0/

 

work for the Red Hat version rhel.3ES. Or, if I have to, how do you totally delete mySQL and then totally re-install it?

[andrewgauger]

Might be the version of Red Hat.  The rpms you need might require a higher kernel.  I always recompile my versions of MySQL and PHP.  Then again, I'm also putting pressure on getting RHEL 5.5, because 5.4 is outdated (In my opinion). 

 

See if this helps, not sure if the solutions is at the bottom. 

 

rpm -Uvh MySQL-*5.0.24-0.glibc23.i386.rpm

 

http://www.linuxquestions.org/questions/linux-server-73/upgrading-php-and-mysql-805958/