Upgrading from MySQL 4.1.21 to 4.1.22 on Red Hat Enterprise LinuxEdit

Created , updated

The upgrade

mkdir mysql-4.1.22
cd mysql-4.1.22
wget \
  http://dev.mysql.com/get/Downloads/MySQL-4.1/MySQL-server-standard-4.1.22-0.rhel3.i386.rpm/from/http://mysql.rediris.es/ \
  http://dev.mysql.com/get/Downloads/MySQL-4.1/MySQL-client-standard-4.1.22-0.rhel3.i386.rpm/from/http://mysql.rediris.es/ \
  http://dev.mysql.com/get/Downloads/MySQL-4.1/MySQL-shared-standard-4.1.22-0.rhel3.i386.rpm/from/http://mysql.rediris.es/ \
  http://dev.mysql.com/get/Downloads/MySQL-4.1/MySQL-shared-compat-4.1.22-0.rhel3.i386.rpm/from/http://mysql.rediris.es/ \
  http://dev.mysql.com/get/Downloads/MySQL-4.1/MySQL-devel-standard-4.1.22-0.rhel3.i386.rpm/from/http://mysql.rediris.es/ \
  http://dev.mysql.com/get/Downloads/MySQL-4.1/MySQL-standard-debuginfo-4.1.22-0.rhel3.i386.rpm/from/http://mysql.rediris.es/
  • Check MD5 checksums:
openssl md5 *
  • The standard shared libraries won’t be installed, so stick them elsewhere:
mkdir not-installed
mv MySQL-shared-standard-4.1.22-0.rhel3.i386.rpm not-installed/
  • Bearing in mind the missing shared compatibility libraries in the last upgrade, double-check the contents of the RPM:
rpm -q --dump --package MySQL-shared-compat-4.1.22-0.rhel3.i386.rpm

Yields:

/usr/lib/libmysqlclient.so 24 1162837883 00000000000000000000000000000000 0120777 root root 0 0 0 libmysqlclient.so.14.0.0
/usr/lib/libmysqlclient.so.10 24 1162837883 00000000000000000000000000000000 0120777 root root 0 0 0 libmysqlclient.so.10.0.0
/usr/lib/libmysqlclient.so.10.0.0 224606 1162837883 579c6fecfad48cb3e8748811026f4890 0100755 root root 0 0 0 X
/usr/lib/libmysqlclient.so.12 24 1162837883 00000000000000000000000000000000 0120777 root root 0 0 0 libmysqlclient.so.12.0.0
/usr/lib/libmysqlclient.so.12.0.0 251559 1162837883 2fae279de1a3929b178d89333103eacc 0100755 root root 0 0 0 X
/usr/lib/libmysqlclient.so.14 24 1162837883 00000000000000000000000000000000 0120777 root root 0 0 0 libmysqlclient.so.14.0.0
/usr/lib/libmysqlclient.so.14.0.0 1174788 1162837883 ba0a9fc64a8f0d2e66f5ffb0ddd7ead1 0100755 root root 0 0 0 X
/usr/lib/libmysqlclient_r.so 26 1162837883 00000000000000000000000000000000 0120777 root root 0 0 0 libmysqlclient_r.so.14.0.0
/usr/lib/libmysqlclient_r.so.10 26 1162837883 00000000000000000000000000000000 0120777 root root 0 0 0 libmysqlclient_r.so.10.0.0
/usr/lib/libmysqlclient_r.so.10.0.0 230560 1162837883 f358f523cb4a364eb8105d9a0f49f943 0100755 root root 0 0 0 X
/usr/lib/libmysqlclient_r.so.12 26 1162837883 00000000000000000000000000000000 0120777 root root 0 0 0 libmysqlclient_r.so.12.0.0
/usr/lib/libmysqlclient_r.so.12.0.0 259501 1162837883 ab26ebef4759527211545190ccedebb5 0100755 root root 0 0 0 X
/usr/lib/libmysqlclient_r.so.14 26 1162837883 00000000000000000000000000000000 0120777 root root 0 0 0 libmysqlclient_r.so.14.0.0
/usr/lib/libmysqlclient_r.so.14.0.0 1182664 1162837883 722f2db76712ee48801b36c0bbe052f7 0100755 root root 0 0 0 X 

So it appears that they are all there.

  • Perform a test run:
for RPM in $(ls *.rpm); do rpm -Uvh --test "$RPM"; done

No problems:

warning: MySQL-client-standard-4.1.22-0.rhel3.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
warning: MySQL-devel-standard-4.1.22-0.rhel3.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
warning: MySQL-server-standard-4.1.22-0.rhel3.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
warning: MySQL-shared-compat-4.1.22-0.rhel3.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
warning: MySQL-standard-debuginfo-4.1.22-0.rhel3.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
  • Perform the actual upgrade:
sudo service httpd stop
sudo service mysql stop
sudo rpm -Uvh --nodeps *.rpm
sudo service httpd start

Downtime was less than 60 seconds.

Post-upgrade checks

  • Confirm that Apache and MySQL are running:
sudo service --status-all | grep httpd
ps auxww | grep -i mysql
rpm -qa | grep -i mysql
  • Check that MySQL is still configured to start automatically at boot:
sudo chkconfig --list | grep -i mysql

See also