How-to upgrade Mysql

[fdr2004]

I have Now

Plesk 7.5 and Mysql 3.23.58-16.RHEL3.1

upgrading mysql 3.23 on ES3

To 4.00 our more

How to do this without messing up my server.

[zCat]

This question belongs in the Database forum ( [webmasterworld.com...] ), maybe a moderator can move it?

Basically it's a question of stopping your database server; upgrading the software packages (probably RPMs in this case), and restarting the server. MySQL doesn't (usually) require that a database be exported and reimported when upgrading the server version, so you can (probably) leave the data files in situ.

The MySQL documentation at dev.mysql.com is worth checking for upgrade notes.

How you do this in your particular environment I'm not sure, I'm not familiar with Plesk and Co.

[mack]

I highly recomend backing up your data before you actualy carry out the update. If nothing else it helps with piece of mind.

Mack.