Upgrade PHP, MySQL and vBulletin...

[GeorgeIII]

I have a VB site that sat idle for some time which I need to bring back into service. I would like to bring it up to date but that requires updates to PHP, MySQL and vBulletin.

I have a few questions on this process.

Currently the site is running:

Windows Server 2003, IIS, PHP 4.3.11, MySQL 4.1.11 and vBulletin 3.62

1. What order should I do the upgrades in? I would assume: PHP, MySQL, and then vBulletin.

2. I downloaded PHP 5.2.4. It wants to install to c:\program files\PHP rather than the current c:\php. Is that good or should I overwrite c:\php?

3. Is there a list posted someplace of the steps I need to upgrade MySQL v4 to v5 without mucking up a vBulletin database?

Thanks for any help.

George III.

[Wayne Luke]

1) PHP & MySQL installation order doesn't really matter on Windows unless you're compiling from source. I'd suggest upgrading vBulletin after these two.

2) I always overwrite my previous installation.

3) Backup your existing database before running MySQL's installation program. That is about it as far as I am aware.

[GeorgeIII]

Bugger.

I ran the PHP install for PHP5.2.4, included the MySQL functions and rebooted.

Now I get 404 errors when I try to access the site. I'm guessing it has something to do with the php ini files?

[Wayne Luke]

The install doesn't include all the files.

You probably want to implement PHP via FastCGI under IIS. Read these two articles:
http://www.iis.net/articles/view.aspx/IIS7/Hosting-Web-Applications/PHP/Configuring-FastCGI-Extension-for-IIS6-0-and-IIS5-
http://www.iis.net/articles/view.aspx/IIS7/Hosting-Web-Applications/PHP/Using-FastCGI-to-Host-PHP-Applications-on-IIS-6-0-