Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2272
  • Last Modified:

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
0
shaunwingin
Asked:
shaunwingin
  • 4
  • 3
1 Solution
 
arnoldCommented:
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.
0
 
shaunwinginAuthor Commented:
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
0
 
arnoldCommented:
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
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
SandyCommented:
yum update
0
 
shaunwinginAuthor Commented:
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?
0
 
arnoldCommented:
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?
0
 
shaunwinginAuthor Commented:
One from Mysql  -can you direct me to 3rd party to try pls
0
 
arnoldCommented:
Please refer to the link.
http://www.tecmint.com/install-mysql-on-rhel-centos-6-5-fedora-17-12/
It guides you step by step on adding a repository from which mysql-5.5. can be installed using yum.

If this is a production system, make sure you have a good backup.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now