MySQL Upgraded to 5.0.86
September 25, 2009 by Jason · 34 Comments
According to the MySQL web site, 5.0.86 has been available since September 9th. I honestly have no idea why, just last week, I built packages for 5.0.84 rather than this newest version. Anyway, the repos have been updated with packages for 5.0.86 and I made a small change so I believe these should also update correctly on systems that have a "mysql-libs" package installed without forcing you to first remove your existing install.
Update #1 (2009/09/28): It's been brought to my attention that these packages will overwrite your old my.cnf. This will be fixed in the next release, but for now, make a backup of your config before updating.
Update #2 (2009/09/28): The reason for the config glitch is because I put it into two packages... New RPMs coming later today; MySQL takes forever to build...
Update #3 (2009/09/28): Newer packages are up, ignore previous updates.
Hi. I thought I'd let you know that updating to 5.0.86 will overwrite your my.cnf file without making a rpmsave or rpmnew
Hmmm... That's not right... I'll fix that in the next release, thanks.
Hi Jason,
Does this make sense ? It looks like a typo or perl-DBD is missing form your latest build.
See below:
yum install mysql-server
---> Package mysql-server.x86_64 0:5.0.86-jason.2 set to be updated
--> Processing Dependency: perl-DBD-MySQL for package: mysql-server
--> Finished Dependency Resolution
mysql-server-5.0.86-jason.2.x86_64 from utterramblings has depsolving problems
--> Missing Dependency: perl-DBD-MySQL is needed by package mysql-server-5.0.86-jason.2.x86_64 (utterramblings)
Error: Missing Dependency: perl-DBD-MySQL is needed by package mysql-server-5.0.86-jason.2.x86_64 (utterramblings)
@Kevin,
The perl-DBD-MySQL package is available as a part of the core CentOS repos for both EL4 and EL5. If it's missing from your system and is not automatically installing then run "yum install perl-DBD-MySQL".
Hi, Yes I have already done that, sorry I shoul dhave mentioned it in my earlier post.
[[email protected]]# yum install perl-DBD-MySQL
Loaded plugins: security
rhel-debuginfo | 951 B 00:00
utterramblings | 951 B 00:00
Setting up Install Process
Parsing package install arguments
No package perl-DBD-MySQL available.
Nothing to do
@Kevin,
It's not working because you're not checking the "Base" and "Updates" repos. What distro is this? RHEL or CentOS? 4 or 5? Is this a dedicated server or a VPS (some VPS providers disable those repos).
Checking further into this issue, it appears this package is not available from the planet's Redhat EL5 repo,
but is available from the CentOS one, example:
http://yum.theplanet.com/5.3/os/i386/CentOS/
I am running rhel 5.0 x86_64
thanks for the reply, assistance, and maintaining your repo - . 🙂 have a nice weekend....
Update worx fine for me! Thanx!
... and noq please go ahead for mod_security *fg*
I had a problem with /usr/share/mysql/english/errmsg.sys reporting as being outdated. Granted, I was going from the OOB mysql packages to Jason's (which saves me a ton of work -- thanks for providing this service). To fix the issue, I had to download the full mysql distribution from mysql.org and copy over the errmsg.sys file. All is great now.
Again - thanks for providing this repo. It's a lifesaver.
How do I find the correct /usr/share/mysql/english/errmsg.sys file. This has been giving me problems for some time now. I'm going crazy. Please give me detail instructions on how to solve this problem. It is greatly appreciated. I need to end this nightmare. My server has been down for days because of this all because I did a simple update. Thanks for you help in advance and for maintaining your repo. Here is the error message I get:
Error message file '/usr/share/mysql/english/errmsg.sys' had only 480 error messages,
but it should contain at least 481 error messages.
Check that the above file is the right version for this program!
@Smyles,
That is not something I've been able to duplicate (What distro are you using? Arch? What version of MySQL was installed before?) but the commenter above you (Steve) did. You can either try what he did or try removing and then reinstalling MySQL.
Same thing, same error. CentOS 5.4 as original install.
Mysql was removed prior to update to this repo version
@Alexander,
When you uninstalled the old version, did it leave that file behind? I've just tested this a half-dozen times and I can't duplicate the error.
I'm going to push out 5.0.87 packages within the next couple days so we'll see if that resolves the issue for everyone.
I just had the same problem after a clean CentOS 5.4 install. First removed the default mysql package, then installed mysql & mysql-server from utterramblings. Also solved it by overwriting the errmsg.sys from the original package. I kept both files, if you're interested?
That's greate. This error can also be solve by removing and reinstalling and then running mysql_install_db. But I would very much like the file if you could send it to me
Anyone been able to figure out the english.sys problem yet?!??! Mysqld will NOT start..
Running Centos 5.4........ after upgrading I had the same "english/errmsg.sys" problem with this error message:
Error message file '/usr/share/mysql/english/errmsg.sys' had only 480 error messages,
but it should contain at least 481 error messages.
Check that the above file is the right version for this program!
Problem solved by overwriting the errmsg.sys from the original package. as described here...
Thanks
Hi!
I am runing CentOs 5.4 and MYSql 5.0.86.janson and it work everithing just fine.
But what about any newer MySql, I saw v 5.1.43?
Any chance you can include the php-rrdtool module in the next build of PHP?
waiting for newer versions of mysql.. v5.1.4x
thanks for your efforts
I think I found out why.
During the yum install (upgrade) process some 5.0.x components are kept or installed.
I had to select one bye one component to be upgraded and it worked fine.
Here's what I have done succesfully to solve this problem :
1. Removed the packages :
yum remove php-common
yum remove mysql mysql-devel mysql-server
2. Installed them again, BUT disabling the utterramblings-repo :
yum --disablerepo=utterramblings install mysql mysql-devel mysql-server perl-DBD-mysql libdbi-dbd-mysql php-mysql
My database now starts with its datafiles intact.
Apparenly I missed something, because after a while my sites stopped working (they probably were from the beginning, but the cache was kicking in ...) . Thinking I probably missed reinstalling a package, I reinstalled everything that got uninstalled by checking the yum-log :
yum --disablerepo=utterramblings install mysql-devel mysql-server mysql perl-DBD-mysql libdbi-dbd-mysql mysql-devel php-mysql mysql
yum --disablerepo=utterramblings install php-pear php-mcrypt php-devel php-xml php-common php-pdo php php-cli php-bcmath php-mbstring php-gd
Now everything seems to work properly again even after a reboot.
Hey Jason,
Just wondering if there's some reason why you're hanging tough with 5.0.86 instead of going with MySQL 5.1.X.
I've been running your builds of mysql and php for quite a long time and really appreciate you making your repo publicly available.
Thanks!
Ritz
I had the following on fresh install of Centos 5.4:
---
Error message file '/usr/share/mysql/english/errmsg.sys' had only 480 error messages,
but it should contain at least 481 error messages.
Check that the above file is the right version for this program!
---
Solution:
1) cp /usr/share/mysql/english/errmsg.sys /usr/share/mysql/english/errmsg.sys.backup
2) Download http://downloads.mysql.com/archives/mysql-5.0/mysql-5.0.86.tar.gz
3) tar -xzvf http://downloads.mysql.com/archives/mysql-5.0/mysql-5.0.86.tar.gz
4) cp mysql-5.0.86/sql/share/english/errmsg.sys /usr/share/mysql/english/errmsg.sys
5) mysql_install_db
6) service mysqld start
(chkconfig mysqld on)
waiting for newer versions Mysql 5.1.4x, Apache 2.2.15, PHP 5.2.13
thanks
Nobody's stopping ya from freshening up those SRPMs that are made available here:
http://www.jasonlitka.com/media/SRPMS/
Dragos Rusu,
Thanks for your howto on the fix for this. It worked!! Now mysql is running fine again. Excellent
Trys
Any chance of mysql 5.0.90 soon.
Thanx for the great work.
regards,
It seems to be that this yum repo is dead ... no more updates from long time ago.
@Deep,
Yes, 5.0.90 is coming tomorrow. Maybe today if I don't get slammed with work.
Changed my mind, 5.0.91 instead.