Parallels Virtualization and Automation Software

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.