apache 1.3 -> 2.2.6 php 4.x -> php 5 & mysql 4 -> 5

[qwerty]

I'd like to upgrade all 3, apache php and mysql to the latest major versions. Currently we use apache 1.3, php4 and mysql 4

I was just wondering if anyone who's been through it before could recommend the best sequence in which to do this ..

My understanding is that you need to recompile apache after upgrading mysql so I was thinking maybe we should upgrade mysql first (tweak settings in whm set to 5.0 and then run /scripts/mysqlup) and AFTER that is done recompile apache to 2.2 with php5 Is that right?

By the way has anyone noticed any issues when going from php4 to php5 ? We've already updated mysql to 5 on one server and there were no issues whatsoever but I don't think we've upgraded from php4 to 5 on any of the servers yet ... Cheers

[cPanelDavidG]

My understanding is that you need to recompile apache after upgrading mysql so I was thinking maybe we should upgrade mysql first (tweak settings in whm set to 5.0 and then run /scripts/mysqlup) and AFTER that is done recompile apache to 2.2 with php5 Is that right?

You will need to recompile Apache/PHP after upgrading MySQL. Are you upgrading from MySQL 4.0 or 4.1? I ask because if you are on 4.0, you may wish to go through the pain of upgrading first to 4.1 before going to 5. Most seem to say that going from MySQL 4.1 to 5 isn't much of a hassle, but going from 4.0 to 4.1 is a hassle.

I agree with the method of doing one thing at a time, in case PHP scripts break you know right away it's a MySQL issue rather than a PHP issue and so forth.

[qwerty]

upgrading from mysql 4.1 ... So you agree that I should do mysql first and then apache/php since it needs to be recompiled after mysql upgrade anyway

anything else I should watch out for ? Cheers

[cPanelDavidG]

upgrading from mysql 4.1 ... So you agree that I should do mysql first and then apache/php since it needs to be recompiled after mysql upgrade anyway

anything else I should watch out for ? Cheers

Yes, and perhaps space the upgrades out a little (perhaps a day or so), so if something breaks you know what you have done. MySQL is a nice first choice because it is the least likely to cause issues. With moving to PHP 4 to 5, you can have users' code breaking due to incompatibility with PHP 5.

Apache shouldn't be that big a deal so long as you've moved to PHP 5 first. PHP 4 doesn't seem to run as well with Apache 2 as it did with Apache 1. So it makes sense to first upgrade PHP (the most likely to cause issues due to incompatibilities of very old/poor PHP code with PHP 5) before upgrading Apache.