Solved

Upgrade MySQL version 5.0.95 to Ver 5.5 on Centos

Posted on 2013-01-01
8
2,079 Views
Last Modified: 2013-01-02
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
Comment
Question by:shaunwingin
  • 4
  • 3
8 Comments
 
LVL 77

Expert Comment

by:arnold
ID: 38735112
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
 

Author Comment

by:shaunwingin
ID: 38735140
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
 
LVL 77

Expert Comment

by:arnold
ID: 38735283
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 13

Expert Comment

by:Sandy
ID: 38735763
yum update
0
 

Author Comment

by:shaunwingin
ID: 38736170
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
 
LVL 77

Expert Comment

by:arnold
ID: 38736687
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
 

Author Comment

by:shaunwingin
ID: 38736927
One from Mysql  -can you direct me to 3rd party to try pls
0
 
LVL 77

Accepted Solution

by:
arnold earned 500 total points
ID: 38736984
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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Have you ever been frustrated by having to click seven times in order to retrieve a small bit of information from the web, always the same seven clicks, scrolling down and down until you reach your target? When you know the benefits of the command l…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question