Upgrading Mysql to 4.1.7

[cb49747]

Hello,

I currently run mysql 3.23.58 on a Linux daffy.perf.redhat.com 2.4.18-11

I wanted to update to mysql 4.1.7 and was wondering how easy it? Is it worth it? What are the benifits. What will it do to my current queries that I have written. Most are simple SELECT statements with some INSERT Statements.

Lastly if I should upgrade, what is the best way to do it.

Chris Burger

 

[MorganGreylock]

Well I actually upgraded the same version to 4.1.7 today just to get subqueries to work, and it wasn't bad at all. I just downloaded the server and client rpms from mysql.org, used the rpm --upgrade MySQL-server.xxxxx MySQL-client.xxxxx and it worked great. I'm using phpMyAdmin, and it continued working just fine.

There was a message about running some priviledges command (I forget exactly what it was) but I ran it, and everything worked fine for me. I didn't lose anything. If you need to use subqueries, then this is a good choice for you, since they aren't supported in any version before 4.1 (or maybe 4.0).

Hope that helps.
MG