Upgrading Apache, PHP and MySQL
 

Hi Guys,

Just want to ask regarding upgrading Apache, PHP and MySQL, currently
we have a lot of Linux Servers in our company with running Apache, PHP and MySQL.

My question is, when I use the command

rpm -Uvh <rpm package>

is there a tendency that my current configuration would be replaced or messed up? Or it would be the same configuration and nothing change?

another upon upgrading MySQL, would the Data would be lost upon upgrade?

Regards,
gurl4sh24

i guess it would be quite useful to know what distros are in use and how old the old versions are.Are the old versions running apache2? Mysql4.x or 5.x? PHP4 or 5?
A change from apache1 to 2 could cause problems, a change from mysql4.0 or older to 4.1 or 5 may require changes in applications. Even changes from php4 to 5 may need a few changes in applications, but not so likely...

Hi, I'm using Red Hat Enterprise Linux ES 4, and most services to be upgrade are:

MySQL 4.1.9 ---> MySQL 4.1.20-2
Apache 2.0.52 ---> Apache 2.2

When I upgrade to these version, will my config files would be change or will be lost?

Guys? Anyone would like to help me here?

RPM won't overwrite your configuration files. It will create new ones with a *.rpmnew extension. To be on the safe side always back up your configuration files.

what reddazz said. About data being lost when updating MySQL, I've never, ever lost any data due to an update, even with major updates like from mysql 3.x to the 4.x line, sometimes you might have to run some mainteance on your old databases to get them to work with a new major version, but the update certainly shouldn't overwrite any of your data files, ever.

Read the documentation and revision history. As far as I know (example), certain stuff was already deprecated in PHP4 and has been permanently removed from PHP5 (magic_quotes comes to mind if I remember correctly). So if your scripts rely on that, you might have a problem. Similar issues might apply to Apache and MySQL.

The best way is to setup a server and do the exercise there. It gives you the experience and you will quickly find out if stuff works or not so you are prepared. But you have to test every single program/script/etc to make sure that they work with the new software versions.

Hey thanks guys, thanks for the information. really help me a lot =)