MySQL Upgraded to 5.0.86

September 25, 2009 by · 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.

Comments

34 Responses to “MySQL Upgraded to 5.0.86”
  1. Joel says:

    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

  2. Jason says:

    Hmmm... That's not right... I'll fix that in the next release, thanks.

  3. Kevin says:

    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)

  4. Jason says:

    @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".

  5. Kevin says:

    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

  6. Jason says:

    @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).

  7. Kevin says:

    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....

  8. DerFalk says:

    Update worx fine for me! Thanx!

  9. DerFalk says:

    ... and noq please go ahead for mod_security *fg*

  10. Steve says:

    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.

  11. Smyles says:

    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!

  12. Jason says:

    @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.

  13. Alexander V. Smirnov says:

    Same thing, same error. CentOS 5.4 as original install.
    Mysql was removed prior to update to this repo version

  14. Jason says:

    @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.

  15. Joost says:

    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?

  16. smyles says:

    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

  17. Jeff says:

    Anyone been able to figure out the english.sys problem yet?!??! Mysqld will NOT start..

  18. Hany says:

    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

  19. bovcan says:

    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?

  20. Ron Kuris says:

    Any chance you can include the php-rrdtool module in the next build of PHP?

  21. prof.tariq says:

    waiting for newer versions of mysql.. v5.1.4x

    thanks for your efforts

  22. Otto says:

    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.

  23. Bart says:

    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.

  24. Bart says:

    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.

  25. Ritz says:

    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

  26. Dragos Rusu says:

    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)

  27. bovcan says:

    waiting for newer versions Mysql 5.1.4x, Apache 2.2.15, PHP 5.2.13

    thanks

  28. Ritz says:

    Nobody's stopping ya from freshening up those SRPMs that are made available here:

    http://www.jasonlitka.com/media/SRPMS/

  29. Trys says:

    Dragos Rusu,

    Thanks for your howto on the fix for this. It worked!! Now mysql is running fine again. Excellent

    Trys

  30. Deep says:

    Any chance of mysql 5.0.90 soon.

    Thanx for the great work.

    regards,

  31. Irek says:

    It seems to be that this yum repo is dead ... no more updates from long time ago.

  32. Jason says:

    @Deep,

    Yes, 5.0.90 is coming tomorrow. Maybe today if I don't get slammed with work.

  33. Jason says:

    Changed my mind, 5.0.91 instead.

Trackbacks

Check out what others are saying about this post...
  1. /usr/share/mysql/english/errmsg.sys had only 480 error messages says:

    [...] solución la encontré en la misma web de Jason, y es sencilla, descargamos paquete, descomprimimos y reemplazamos el archivo de idiomas que da [...]



This site is no longer updated. If you have a need for RHEL/CentOS LAMP Stack updates outside the normal channels, I recommend ART. https://updates.atomicorp.com/channels/