MySQL Upgrading

[zilm]

Hello.
My box is running Plesk 8.1.10 and i need to upgrade Mysql to last version from sources tarball. I'm stumped because ./configure uses /usr/local by default for installation. But all mysql currently installed files are in different directories: binaries in /usr/bin, .so in /usr/lib/mysql, .h in /usr/include/mysql, databases in /var/lib/mysql etc...What options should i use to upgrade it correctly?

 

[Hedgren]

As far as i know, it is not recommended upgrading mysql to the 'latest version', as Plesk 8.1.1 fully supports MySQL 5.0, whereas 5.1+ are still unstable.
Since mysql is not part of Plesk, SWsoft does not build its own mysql. Plesk uses standard services which are installed on the system. If mysql is found on the system where Plesk is installed, Plesk will use them. If these installations are not found, Plesk will download and install standard packages of OS vendor.
You see, Plesk is mainly tested on and oriented to standard OS installations with standard packages from OS vendor.
So, why not taking Mysql 5.0 from the OS distribution and installing it by means of the OS packet in order to avoid possible dependencies conflicts?
If you're still wishing to compile it from the sources, i guess MySQL homeforum at www.mysql.org is a better place to check.