Upgrade mysql

Upgrading MySQL under Red Hat 8

This article explains how to upgrade the MySQL which ships with Red Hat 8. That is, from MySQL V 3.23.52-3 to V 4.0.16-0.

I installed MySQL from the Red Hat disks, so it was installed as a Red Hat package.

Red Hat 8 includes the Perl interface to MySQL, DBD::mysql. So, in the process, we uninstall the old version of DBD::mysql, and install V 2.9003.

Downloading MySQL

I downloaded 4 files, because I want everything to be available when I compile the Perl interface:

	MySQL-server-4.0.16-0.i386.rpm
	MySQL-shared-4.0.16-0.i386.rpm
	MySQL-client-4.0.16-0.i386.rpm
	MySQL-devel-4.0.16-0.i386.rpm

Put these in /tmp.

GUI 'v' Command Line for rpm

rpm is the Red Hat Package Manager.

I chose to use the command line, so we run these steps in this order:

	shell>cd /tmp
	shell>rpm --nodeps perl-DBD-mysql

The --nodeps tells rpm to ignore the inter-dependencies between MySQL itself and the Perl interface. Otherwise, rpm exits with a warning and does not actually do anything.

The same thing happens if you try to run the next command first, so the --nodeps options is the only way to go.

	shell>rpm -e mysql

Note: The seems to be no case-sensitiviy with this command.

Now, install the new version. These commands refer to real, live files, and so are case-sensitive:

	shell>rpm -i MySQL-server-4.0.16-0.i386.rpm
	shell>rpm -i MySQL-shared-4.0.16-0.i386.rpm
	shell>rpm -i MySQL-client-4.0.16-0.i386.rpm
	shell>rpm -i MySQL-devel-4.0.16-0.i386.rpm

GNU make

These instructions assume you are using GNU make. I call it make, while some packages call it gmake to clarity.

The Perl interface DBD::mysql V 2.9003

Download DBD-mysql-2.9003.tar.gz from CPAN, into /tmp.

	shell>cd /tmp
	shell>gunzip DBD-mysql-2.9003.tar.gz
	shell>tar xvf DBD-mysql-2.9003.tar
	shell>cd DBD-mysql-2.9003
	shell>perl Makefile.PL
	shell>make
	shell>make test
	shell>su
	shell>make install
	shell>exit

That's it!

Starting the server

	shell>cd /etc/rc.d/init.d
	shell>./mysql start

and

	shell>./mysql stop

There are comments in /etc/rc.d/init.d/mysql about automatically starting the server at boot time.

Author

Ron Savage.

Home page: http://savage.net.au/index.html

This POD was converted to HTML by /Perl.html#fancy-pom2.pl

• Version: 1.01 01-Jun-2006

  This version disguises my email address.

• Version: 1.00 11-Jan-2004

  Original version.

Licence

Australian Copyright © 2002 Ron Savage. All rights reserved.

	All Programs of mine are 'OSI Certified Open Source Software';
	you can redistribute them and/or modify them under the terms of
	The Artistic License, a copy of which is available at:
	http://www.opensource.org/licenses/index.html