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

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.

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

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!?)

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"

Thank you very much. I will try it.

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

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.