LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 02-13-2006, 08:06 PM   #1
edudirectories
LQ Newbie
 
Registered: Feb 2006
Posts: 9

Rep: Reputation: 0
Upgrading MySQL 5.0


I am using RHEL 4.0 with MySQL 4.1 on there and trying to upgrade to MySQL 5.0. I was wondering if anyone was able to do so. I am having a real hard time doing so - running into alot of dependancy issues..
 
Old 06-30-2006, 03:09 AM   #2
timtak
LQ Newbie
 
Registered: Jan 2004
Posts: 22

Rep: Reputation: 0
I wish I knew too. I am using redhat linux 9 so I guess I am facing even more problems.
With the new features of recent version of mysql there must be vast numbers of people wanting to upgrade their mysql installations. But I see no easy way of doing so.
 
Old 06-30-2006, 04:56 AM   #3
pikky2006
LQ Newbie
 
Registered: Jan 2006
Location: Delhi India
Distribution: Fedora Core Redhat9 RHEL ES/AS
Posts: 14

Rep: Reputation: 0
Re MySQL upgrade


I m also using redhat 9 and i success fully upgraded to MySQL 5 using rpms found on the MySQL site. Simply upgrade the rpms using rpm -U
 
Old 06-30-2006, 05:54 AM   #4
timtak
LQ Newbie
 
Registered: Jan 2004
Posts: 22

Rep: Reputation: 0
which mysql rpms for redhat9

Dear pikky

Thank you very much for your reply. I had never heard of "rpm -U" -- I thought one had to use yum or apt-get.

Alas however, I am at a loss as to which rpms to download
This is the download page but Redhat 9 is not mentioned (only Redhat Enterprise)
http://dev.mysql.com/downloads/mysql/5.0.html

Which distribution's rpms did you use?

And of the 7 in each category of distribution, did you use all seven?
E.g. for Red Hat Enterprise Linux 3 RPM (x86), there are
  1. Server 5.0.22-0 11.9M
  2. Client 5.0.22-0 6.5M
  3. Shared libraries 5.0.22-0 1.5M
  4. Shared compatibility libraries (3.23, 4.x, 5.x libs in same package) 5.0.22-0 2.8M
  5. Headers and libraries 5.0.22-0 3.3M
  6. Test suite 5.0.22-0 4.9M
  7. Debug information Standard 5.0.22-0 19.7M
Did you install all 7?

Do all these packages get a mention in the same rmp -U call or does one do it order?
If all in the same call are they simply space seperated?
Do they have to be downloaded to a particular folder?

Is a problem to upgrade from 3.x to 5.x or should I do it in stages?

I hear that a late version of 4 (4.16 or above, and they are now on 4.2) would be sufficient for my needs. So I think that I will use the rpms here
http://dev.mysql.com/downloads/mysql/4.1.html
But all the same there is no mention of redhat 9.

My guess is that the
Linux x86 generic RPM (statically linked against glibc 2.2.5) downloads
is the best bet (but only because it says it is "generic")

I would be very very grateful of any further information.

Thanks,
Timothy Takemoto

PS I replied at much greate length than the above, but at so much length that my login timed out and when I went to post I was instructed to log in again and when I did so my post was lost! Ouch!! (Do you hear that administrator!?)

Last edited by timtak; 06-30-2006 at 06:06 AM.
 
Old 07-01-2006, 12:53 AM   #5
pikky2006
LQ Newbie
 
Registered: Jan 2006
Location: Delhi India
Distribution: Fedora Core Redhat9 RHEL ES/AS
Posts: 14

Rep: Reputation: 0
Update...


Dear timtak,
i wish there could be rpms for redhat9 but we've no choice i've downloaded Linux x86 generic RPM (statically linked against glibc 2.2.5) and installed it on my server machine and it's running fine u dont have to download all rpms u need
1. MySQL-server
2. MySQL-client
3. MySQL-devel
4. MySQL-shared
5. MySQL-shared-compat
and 6. MySQL-bench
just download them in a folder and install with
# rpm -U MySQL-*
resolve dependencies if any......
think it should work

OK Bye....

And one more thing dont tell me that - u not heard about "rpm -U"

Last edited by pikky2006; 07-01-2006 at 12:56 AM.
 
Old 07-01-2006, 01:37 AM   #6
timtak
LQ Newbie
 
Registered: Jan 2004
Posts: 22

Rep: Reputation: 0
Thank you very much. I will try it.
 
Old 07-02-2006, 04:01 AM   #7
timtak
LQ Newbie
 
Registered: Jan 2004
Posts: 22

Rep: Reputation: 0
Yes! Thank you Pikky!

I made the mistake of performing the upgrade while the mysql sever was running. This caused a bit of a glitch. It told me that it could not start mysql because another mysql is running, and the start and stop commands in my webmin were not functioning. but when I rebooted and started the database using webmin, it says that the database is
MySQL version 4.1.20
success. Perhaps I will upgrade to version 5.0 for good measure. Perhaps another day.

I may be having some problems talking to my database though. I can talk to it through webmin but not with commands on the commandline. It could be something to do with this....

"Please see the Security section of the manual to find out how to run mysqld as root!"

But anyway, I have Mysql upgraded on my sever. It seems to be working fine.

Thanks again
Tim
 
Old 07-02-2006, 04:24 AM   #8
timtak
LQ Newbie
 
Registered: Jan 2004
Posts: 22

Rep: Reputation: 0
I think that it seems to work okay when I use --password=mypassword in mysqladmin commands. It is interesting that "root" is not the same as the linux kernel root.
 
  


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
Error compiling perl-DBD-MySQL after upgrading to MySQL 4.1 pitaro920 Linux - Software 1 01-16-2006 05:28 PM
Upgrading mySql from 3.23 to 4.1.10 atomicx Linux - Software 2 02-22-2005 11:54 AM
Upgrading to MySQL 4.1 allelopath SUSE / openSUSE 0 02-03-2005 07:47 PM
upgrading mysql mabus92920 Linux - Newbie 2 01-16-2005 10:35 AM
Upgrading to Mysql 4.0 ombill Fedora 1 08-19-2004 12:29 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 03:21 AM.

Main Menu
Advertisement
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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration