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.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Introduction to Linux - A Hands on Guide
This guide was created as an overview of the Linux Operating System, geared toward new users as an exploration tour and getting started guide, with exercises at the end of each chapter.
For more advanced trainees it can be a desktop reference, and a collection of the base knowledge needed to proceed with system and network administration. This book contains many real life examples derived from the author's experience as a Linux system and network administrator, trainer and consultant. They hope these examples will help you to get a better understanding of the Linux system and that you feel encouraged to try out things on your own.
Click Here to receive this Complete Guide absolutely free.
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.