View the Most Wanted LQ Wiki articles.
Go Back > Forums > Linux Forums > Linux - Server
User Name
Linux - Server This forum is for the discussion of Linux Software used in a server related context.


  Search this Thread
Old 11-16-2012, 11:40 PM   #1
LQ Newbie
Registered: Jan 2012
Posts: 18

Rep: Reputation: Disabled
Using YUM to upgrade Mysql

Originally, until half an hour ago, I was running mysql (server) version 5.0.45-7.el5.

Want to upgrade to v.5.1.

Never done this before, or anything like it. I backed up all databases, stopped the mysqld service and typed:

# yum install MySQL-server-5.1.60-1.glibc23.i386.rpm

YUM said:

Error: mysql conflicts with MySQL

That seemed fair enough since the two versions are not compatible. So, I typed:

# yum remove mysql

That was fine.

Finally I tried again to install the new mysql version:

# yum install MySQL-server-5.1.60-1.glibc23.i386.rpm

and got the messages:

warning: rpmts_HdrFromFdno: V3 DSA signature: NOKEY, key ID 5072e1f5
Public key for MySQL-server-5.1.60-1.glibc23.i386.rpm is not installed

I can't start the mysql daemon and

# yum list MySQL

shows no trace of the package.

I tried a localinstall from a downloaded rpm file and got exactly the same result.

I hope this is something simple - it's a production server and I have to get it going again!
Old 11-17-2012, 12:05 AM   #2
John VV
LQ Muse
Registered: Aug 2005
Posts: 15,893

Rep: Reputation: Disabled
I was running mysql (server) version 5.0.45-7.el5.
el5 means that this is "one" of the redhat 5 ( RHEL 5.0,5.1,5.2,5.3,5.4,5.5,5.6,5.7,5.8 )
CentOS 5.8 or Scientificlinux 5.8 ( both cent and sl ONLY support the current version in the major version)

so WHAT operating system are you using ?

RHEL is NOT free and you MUST have the REQUIRED support contract to install software
one of the FREE rebuilds ????
cent or SL


that error is from trying to install an incompatible rpm BYPASSING the distros repo

the "glibc23" on the end of that "Random" rpm file
means you MUST have a operating system BUILT with glibc 2.3
the rpm MUST MATCH your system

there is nothing i can offer untill you inform us as to what you are using

other than USE your operating system's update and base repo
su -
yum update mysql
build and install from source the database and ALL of it's prerequisites
and for a mismatching libc
that is 80% of the operating system

exactly what operating system is it ?
2) and what version is it ?

blindly trying to bypass the safeguards in "yum" and installing an incompatible rpm from some " random place on the web"
is NEVER a good idea
Old 11-17-2012, 12:28 AM   #3
LQ Newbie
Registered: Jan 2012
Posts: 18

Original Poster
Rep: Reputation: Disabled
[root@monkey downloads]# cat /etc/*-release
CentOS release 5.2 (Final)

That's the OS. Can't make out whether you were asking anything else.

I want v5.1 of mysql. If you know how I should go about installing it, please let me know. I don't believe it is impossible.
Old 11-17-2012, 01:00 AM   #4
John VV
LQ Muse
Registered: Aug 2005
Posts: 15,893

Rep: Reputation: Disabled
cent STOPPED supporting 5.2 a very long time ago
Cent only supports the CURRENT minor version in the major version
Cent5.8 and Cent 6.3 are the ONLY supported versions

please UPGRADE
You have not installed any security fixes sense "2008-05-21" when 5.2 hit "End Of Life"

but if you must use a OS that is vulnerable to EVERY KNOWN security hole for the last 4 years

then build mysql from source

that is really your only option
and hopefully you will not have to rebuild half of the OS to do so ?
but you might !
Old 11-17-2012, 01:13 AM   #5
LQ Newbie
Registered: Jan 2012
Posts: 18

Original Poster
Rep: Reputation: Disabled
Okay, I'll upgrade.

Please bear in mind that I haven't done this before. If I just type

# yum update

and then re-boot, will that do the trick?

Am I likely to hit problems that will make me wish I'd never done it?
Old 11-17-2012, 02:13 AM   #6
John VV
LQ Muse
Registered: Aug 2005
Posts: 15,893

Rep: Reputation: Disabled
on 5.2 you can not do that, that will NOT work
ALL , every and ALL the rpms were removed a long time ago from the folders that are listed in the repo files

EVERY link in that file is dead
you would have to manually point it to the very old and insecure historical vault
and then you can ONLY install rpms that are 4+ years OUT OF DATE

is the very LAST update to 5.2 and that WAS in June of 2008

if you MUST stay wit ha unsupported version of a Operating system ( not recommended )
then you will have to manually build every and ALL prerequisite for that version of MySQL
-- a LOT of work .
Old 11-17-2012, 04:10 AM   #7
LQ Newbie
Registered: Jan 2012
Posts: 18

Original Poster
Rep: Reputation: Disabled
I was asking how to upgrade CentOS 5.2 to something shiny and new, and what the problems were likely to be.

Not sure whether or not you gave an answer???
Old 11-17-2012, 07:56 PM   #8
John VV
LQ Muse
Registered: Aug 2005
Posts: 15,893

Rep: Reputation: Disabled
in that case you will need to do a new CLEAN install of CentOS 6.3
there is no option to upgrade between major versions of the operating system

and the major version of mysql in centos 5.8 will be the SAME as in 5.2


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Yum install mysql mysql-server not working drewdown Linux - Software 3 06-03-2012 11:51 PM
[SOLVED] yum install php-mysql create problem to my running mysql database arun5002 Linux - Server 1 08-11-2011 04:24 AM
yum update fails after FC6->FC9->FC11 upgrade on MySQL-server rpm ericcarlson Fedora 1 07-08-2009 02:06 PM
yum install php-mysql fails with mysql 5.1 - "Error: mysql conflicts with MySQL" rebelde Linux - Software 2 03-13-2009 11:32 AM
Problem Starting MySQL on Fresh Fedora 8 Install w/ Yum'd MySQL blong4life Linux - Server 2 07-04-2008 08:44 PM

All times are GMT -5. The time now is 01:17 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration