Linux - ServerThis forum is for the discussion of Linux Software used in a server related context.
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Can anyone explain how to upgrade MySql from 4.1 to 5.0 in a CentOS 4 server? I can only access it through ssh, so everything needs to be done from the command line. I have tried with 'yum upgrade mysql', but it does not go beyond the current version number and only updates to the latest MySql4 version.
mysql 5 is apparently in the centosplus repositories (unless it's gone more mainline than this... http://bugs.centos.org/view.php?id=1124) so just ensure that your yum repo is enabled for that version and you should then be able to do yum upgrade to it. I'd suggest doing a "yum search mysql" to see all the potential packages available, as in that link you'd want mysql-server, not just mysql
yum search mysql* displays lots of packages, but none of them is from version 5.
And I'm afraid I don't know how to "enable my yum repo for that version". Somewhere else they told me to try:
yum --enablerepo=centosplus upgrade mysql*
but it gives me:
Setting up repositories
Cannot access repository dir //var/cache/yum/centosplus
Error: Cannot access repository dir //var/cache/yum/centosplus
Any more detailed instructions would be appreciated.
Distribution: Debian Wheezy/Jessie/Sid, Linux Mint DE
Be careful about upgrading MySQL 4 -> 5. The versions are NOT completely compatible on the database level. Search for some documentation about it. I forgot which problems it exactly gave, but one of them had to do with passwords.
I ran MySQL 5.0.x on CentOS 4.X without problems but downloaded the RPM's directly from MySQL's site to install from, not yum. 5.0.45 ran without problems, which at the time was the latest stable version available from MySQL in RPM format.
I finally found that there is an option in the repo definition files to disable a given repo. [centosplus] by default contains the line enabled=0, so I commented it out and now yum shows me the Mysql 5 packages and lets me upgrade Mysql to that version.