Upgrading MySQL to latest version 3.23.39 (at time of writing).
Mark Fleeson

FTP the following MySql rpm's from ftp.mysql.com/MySql-3.23
1) Install base rpm
 rpm -iv --force MySQL-3.23.39-1.i386.rpm
2) Find and kill mysql that's just been started.
 ps -ef | grep mysql
 kill <pid nos> i.e. kill 1625 1310 1324 1326
3) Install remaining rpm's
 rpm -iv --force MySQL-client-3.23.39-1.i386.rpm
 rpm -iv --force MySQL-shared-3.23.39-1.i386.rpm

4) Move new files to overwrite old ones.
 cd /usr/lib
 cp libmy* mysql
 cd /usr/libexec
 mv mysqld mysqld.old
 cp /usr/sbin/mysqld .
5) Remove new startup files so that original e-smith ones are used.
 rm /etc/rc.d/rc*.d/*mysql
 rm /etc/rc.d/init.d/mysql
6) Restart mysql
 /etc/rc.d/init.d/mysqld start
7) Check new version
 should result in
 Welcome to the MySQL monitor.  Commands end with ; or \g.
 Your MySQL connection id is 5713 to server version: 3.23.39
If you find this useful then can I ask you to go and see my current client's site.
www.cd-wow.com All chart cd's for 8.99GBP or less including postage and delivery worldwide.
Mark Fleeson
The Burning Light Consultancy
Unix,PHP and MYSQL development.