For the website I created for my workplace we have a dedicated server running PHP 4, Plesk 7 and MySQL 3.xx.
It’s software has never been upgraded, only patched. Now, I am the sole webdeveloper so my laptop is my test machine but I also have my own website and it’s on a shared hosting server running MySQL 5 which I need for various projects based on my domain (note: not publicly available).
Ideally I would like to upgrade the MySQL version on our server to 5 to stop having me go back to the code to edit things for such an outdated version but I’ve read various articles stating a lot of dangers etc. and it’s understandable because of the differences between 3.xx and 5.xx.
I’m not too worried about the website data because I have a fully working copy on my laptop which I can upload but I am worried about the Plesk settings. There are a lot of different domains being hosted on the server.
Any suggestions? 
