mysql upgrade

[Anon]

I am thinking of upgrading from mysql 3.22.32 and am wondering what I should ensure before installing. My main concern is whether or not I need to recompile PHP? Also, will the re-install overwrite my current databases?

Is there any articles available on mysql compliling tips to optimize it's speed? I've read the manual sections on this at mysql.com

Thanks.

[Anon]

Upgrading MySQL does not need a recompile of PHP.

Everything you need to know about optimizing the speed of mysql is in themysql manual under "how compiling and linking affects the speed of mysql"
You say you've read that, so you know just about all there is to know.

An upgrade of mysql will not overwrite your old data, unless you run the "mysql_install_db" script. This script overwrites your "mysql" and "user" table,
erasing your userinfo.

Nevertheless, it's allways good practice to make a backup of your data before you upgrade any software.