Link to home
Start Free TrialLog in
Avatar of Shaun Wingrin
Shaun WingrinFlag for South Africa

asked on

Upgrade MySQL version 5.0.95 to Ver 5.5 on Centos

Say, Current system:

[root@a1 ~]# uname -a
Linux a1.a1telecoms.co.za 2.6.18-238.12.1.el5 #1 SMP Tue May 31 13:23:01 EDT 2011 i686 athlon i386 GNU/Linux
[root@a1 ~]# cat /etc/redhat-release
CentOS release 5.8 (Final)
MySQL version 5.0.95

Please give detailed steps to upgrade to MySQL 5.5
Avatar of arnold
arnold
Flag of United States of America image

You can download RPM from dev.mysql.com
Centos is built on RedHat whose update paths do not include major version transitions.
Are you looking to transition because of a specific feature you need, or because it is newer?

You could install the newer version and then have to update the elated components, for php, etc.
You have to make sure everything else you have is not affected by changes implemented in the newer version versus what was available in the old.
Avatar of Shaun Wingrin

ASKER

I specifically need MYSQL 5.5 - and only interested in it a s MySQL server, the other components are not important. I need 5.5 for the latest ODBC driver to work.
Please give exact links and instructions.
Aside question: Does CentOS 6 include the MySQL 5.5 version?
Tx
No, centos 6.x has mysql5.1.
The server is not the only component your odbc needs, you need all the libraries as well.

Dev.mysql.com

http://dev.mysql.com/downloads/mysql/5.5.html#downloads
Select redhat 5. Which is part of the selection of oracle, redhat 4,5.

Download and install.  Are you absolutely certain that an ODBC connection requires mysql 5.5 or get http://dev.mysql.com/downloads/connector/odbc/#downloads
yum update
Getting error with ODBC and suggestion is to upgrade to 5.5

yum update -  believe CentOS5 stops at MySql 5.1 - can you confirm please?
You could add a fedora repo from which you can install 5.5 but you would have to make sure to maintain it if security updates are neeeded.

http://www.tecmint.com/install-mysql-on-rhel-centos-6-5-fedora-17-12/

Which ODBC are you installing?  Are you installing a third party or one from Mysql.com?
One from Mysql  -can you direct me to 3rd party to try pls
ASKER CERTIFIED SOLUTION
Avatar of arnold
arnold
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial