Details
To upgrade mysql from 4.1 to 5.0, following are the steps:
1. Download the mysql rpm's:
http://dev.mysql.com/downloads/mysql/5.0.html or http://downloads.mysql.com/archives.php?p=mysql-5.0
MySQL-server-standard-5.0.18-0.rhel4.i386.rpm
MySQL-client-standard-5.0.18-0.rhel4.i386.rpm
MySQL-devel-standard-5.0.18-0.rhel4.i386.rpm
MySQL-shared-standard-5.0.18-0.rhel4.i386.rpm
2. For backward compatibility, download the following rpm:
http://dev.centos.org/centos/4/testing/i386/RPMS/mysqlclient14-4.1.14-1.i386.rpm
3. Install the downloaded packages:
a. service mysqld stop
b. rpm -Uvh *.rpm
c. ln -s /etc/init.d/mysqld_app_init /etc/init.d/mysqld
4. Add the following entry in /etc/virtualhosting/filelists/siteinfo.sh
N:S,rpm:MySQL-shared-standard
N:S,rpm:MySQL-client-standard
N:S,rpm:MySQL-devel-standard
N:S,rpm:MySQL-server-standard
N:S,rpm:mysqlclinet14
5. Run the server through maintenance mode:.
a. set_pre_maintenance
b. set_maintenance
c. set_post_maintenance
d service webppliance restart
6. Start mysqld service and verify that the mysqld service is running properly.
| 
