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
 MySQL-3.23.39-1.i386.rpm
 MySQL-client-3.23.39-1.i386.rpm
 MySQL-shared-3.23.39-1.i386.rpm
 
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
 
 mysql
 
 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.
mark@burninglight.com