PHP and MYSQL upgrade

[aopen]

MYSQL 3 and PHP 5 is installed on Linux box. I would like to upgrade MYSQL 3 to MYSQL 5 and PHP 5 to PHP5.2.

1). What I should upgrade first? MYSQL Or PHP
2). Do I have to uninstall PHP 5.0 first?

Thanks

[halojoy]

does not matter which first.

I should start with MySQL .. can be the tricky one.

MySQL, at least when I upgraded last week, ( from one MySQL5.x to a later)
required previous version totally removed.
Several hours of deleting in registry etc. etc.
Backup your mysql data! Make a copy of the '/mysql/data/' folder.

At least for me, in Windows XP, I never need to uninstall PHP, for newer version.
But I never install PHP .. I just download the ZIP file of php5.2.4-win32.zip
and unzip where I want it.

Regards 🙂

[MarkR]

Is this a development or production system?

I'd be very careful upgrading a production system, especially if you have multiple applications on it (or third party ones).

Mysql3 is very ancient and had some strange and broken behaviours (e.g. no collation support). This means that indexes almost certainly have to be rebuilt - you're best dumping and reloading the database - I hope you don't have a lot of data.

I hope this mysql3 / php5 is not your production system - but as a dev system, it should be representative of your production system - but I really hope it isn't.

Mark