LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 04-02-2008, 01:59 AM   #1
czamora
Member
 
Registered: May 2006
Posts: 52

Rep: Reputation: 15
Question Mysql upgrade without GUI


Hi,

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.

I would appreciate any help.
 
Old 04-02-2008, 08:37 AM   #2
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,414

Rep: Reputation: 1967Reputation: 1967Reputation: 1967Reputation: 1967Reputation: 1967Reputation: 1967Reputation: 1967Reputation: 1967Reputation: 1967Reputation: 1967Reputation: 1967
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
 
Old 04-02-2008, 04:03 PM   #3
czamora
Member
 
Registered: May 2006
Posts: 52

Original Poster
Rep: Reputation: 15
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.

Thanks a lot.
 
Old 04-05-2008, 06:04 PM   #4
czamora
Member
 
Registered: May 2006
Posts: 52

Original Poster
Rep: Reputation: 15
Anyone knows how is yum supposed to know the url of repositories? That is, how it translates a name like 'centosplus' into the url where the packages are located?
 
Old 04-05-2008, 06:27 PM   #5
blacky_5251
Member
 
Registered: Oct 2004
Location: Adelaide Hills, South Australia
Distribution: RHEL 4&5, Fedora 10, CentOS 5.4, IPCop
Posts: 569

Rep: Reputation: 55
Look at the files in /etc/yum.repo.d

You should see URL info there.
 
Old 04-05-2008, 09:35 PM   #6
jlinkels
Senior Member
 
Registered: Oct 2003
Location: Bonaire
Distribution: Debian Wheezy/Jessie/Sid, Linux Mint DE
Posts: 4,188

Rep: Reputation: 523Reputation: 523Reputation: 523Reputation: 523Reputation: 523Reputation: 523
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.

jlinkels
 
Old 04-06-2008, 10:11 AM   #7
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 199Reputation: 199
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.
 
Old 04-08-2008, 08:35 AM   #8
czamora
Member
 
Registered: May 2006
Posts: 52

Original Poster
Rep: Reputation: 15
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.

Thanks a lot to you all for your suggestions.
 
  


Reply


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
GUI for mySQL John_Emad Programming 9 11-14-2006 04:30 AM
Upgrade to MySQL-5.0.18 breaks PHP mysql functions MarkVickers Slackware 5 05-03-2006 01:10 AM
MySQL GUI Ellops Linux - Software 2 02-23-2006 07:50 PM
php-mysql dependancy problem after nitemare mysql upgrade. RHEL4 andrewc Red Hat 1 01-03-2006 05:16 PM
mysql 4.0.24 to mysql 4.1.12 upgrade problem tuxrules Slackware 7 08-13-2005 07:43 PM


All times are GMT -5. The time now is 11:25 AM.

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