Upgrade MySQL server to 4.1.22

[rmxs]

Hello im using Centos 4 in one of my servers

Right now tha sql version is 4.1.21 how can i upgade to 4.1.22


I try "rpm -qi mysql"

and i get ''package mysql is not installed ''i thing the mysql installed with direct admin!

Can someone please tell me how can i upgrade the mysql version?

help me please?

 

[Marshall]

Do you have the RPMs on your system? If so go to where they are located (server, client, shared and devel) and go "rpm -Uvh MySQL*.rpm" and if you dont have them downloaded yet, grab them from http://dev.mysql.com/downloads/mysql/4.1.html for your system type then run the command above wherever you downloaded them to.

 

[rmxs]

No i dont thing to have the rpms.

I dont have idea from centos last years i use debian and now all its different!

Can you please post me step by step?

How to grab the CORRECT package etc!

Thanks

 

[Marshall]

On that page scroll down till you see "Red Hat Enterprise Linux 4 RPM (x86) downloads" and grab the Server, Client, Shared Libraries and Headers and libraries. Just go to the pick a mirror section then right click one of the mirrors and go to save URL then in your SSH terminal type

mkdir /usr/local/src
cd /usr/local/src
rm -f MySQL*.rpm
wget [paste url you have in clipboard for each rpm]
rpm -Uvh MySQL*.rpm
service mysqld restart

After that it should be upgraded and you may want to rebuild php to make sure its linking against the new libraries for the new version.

 

[rmxs]

oh that perfect.

Can you please give me a link or some instructions how can i rebuild the php which files to edit etc...i lose my guide and i dont remember

PHP 4.4.4

 

[Marshall]

Easiest way is to use the build script that comes with directadmin

cd /usr/local/directadmin/customapache
./build clean
./build update
./build php n (if using apache 2 do ./build php_ap2 n)
service httpd restart

Then make a test php page in your domain's public_html containing

<?php
phpinfo();
?>

and browse to it to make sure php is working fine (if the page shows up with a bunch of info it means php works) and check out the settings to make sure its all correct.

 

[rmxs]

Oh yes you right that it!

Byt i get this

[root@servers src]# rpm -Uvh MySQL*.rpm
warning: MySQL-client-standard-4.1.22-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
perl(DBI) is needed by MySQL-client-standard-4.1.22-0.rhel4.i386
perl(DBI) is needed by MySQL-server-standard-4.1.22-0.rhel4.i386
[root@servers src]#
[root@servers src]#

 

[Marshall]

Ah you need to install perl-DBI using yum by

yum install perl-DBI

 

[rmxs]

Everything upgraded and works fine!

Someone must make this tutorial

 

[nobaloney]

Debian doesn't use RPMs. So how did you upgrade?

Jeff

 

[Marshall]

He used to use debian, right now he is on CentOS 4 which is why everything is all different for him, he is used to the debian commands and not the CentOS 4 ones.

 

[nobaloney]

Oh. Thanks.

Somehow I got it backwards .

Jeff

 

[rmxs]

Right!

Now i use CentOs..
And i dont have idea...

 

[SlowYaRoll]

I'm with you!!! I started using Linux maybe mid/late 2005. I now work for a web hosting company that uses CentOS.

I'm a UBUNTU GUY!!! I'm beyond lost with RPM stuff.

I <333 apt-get

 

[nobaloney]

I switched from Slackware to RedHat about the time RH Linux 6.2 was released, and it took me about a year to get used to it.

Would I switch again.

Absolutely; if there were a good reason. My reason for sticking with Red Hat right now is that DA is first built on it; everything else is a port.

Is that a good reason? I have no idea.

Jeff