Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Mark Fleeson on July 13, 2001, 04:14:54 PM

Title: Upgrading MYSQL
Post by: Mark Fleeson on July 13, 2001, 04:14:54 PM

Hi,

Has anyone been able to upgrade the 4.1.2 version of MySQL to a later one. I've compared the base rpm's for 3.23.39 to the e-smith 3.23.32 and think I can install the new rpm's and then move/rename a couple of files.

Has anyone else managed to do this, and if not, do you want me to document how I do it if I can get it to work?

Thanks for making an amazing product, having used Redhat since 1994, having so much control over a server is really useful in the real world.

Mark

Title: Re: Upgrading MYSQL
Post by: Mark Fleeson on July 15, 2001, 06:03:00 PM

I've managed to successfully upgrade to mysql .39 latest version. I'll write it up and post it to you.

Thanks

Majr

Title: Re: Upgrading MYSQL
Post by: Mahmood Al-Yousif on July 15, 2001, 09:34:05 PM

Would you mind letting me know the cure too? I would like to update to .39.

Regards
Mahmood

Title: Re: Upgrading MYSQL
Post by: Mark Fleeson on July 16, 2001, 03:16:12 PM

Hi Mahmood.

I've just completed a second upgrade to confirm the instructions below. Hope they're useful. It's kind of the bludgened approach to e-smith installation but it does work!

Best Wishes

Mark

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


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 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

Title: Re: Upgrading MYSQL
Post by: Mahmood Al-Yousif on July 18, 2001, 01:07:04 AM

Thanx for the post Mark!

Mahmood