[ALUG] Red Hat 9 and MySQL-3 --> MySQL-4

[(Ted Harding)]

Hi Folks,

Now a question of my own ... to people who have been
down the road below.

I'm running Red Hat 9 on one machine, along with the
MySQL-3.23.54a which came on the installation CDs.

I want to upgrade the MySQL-3 to MySAL-4+, in order
to have the increased functionality (especially
sub-queries) which was introduced in version 4.

My browsings on the web have not revealed an upgrade
route which looks authoritative, though I have seen
a few people recommend procedures, though not in detail,
and I have not seen confirmations that these have worked.
I really do want to avoid breaking things on that machine!

MySQL is currently at version 5, but older versions
(specifically 4.1.22) are available in various formats
(binary and source) at

  http://dev.mysql.com/downloads/mysql/4.1.html

If anyone has successfully made this upgrade, I would
be most grateful to learn, in detail, how they did it!

With thanks,
Ted.

PS I'm not open to suggestions to upgrade the Linux
installation. That machine is something of an "attic",
and renewing its joists is not compatible with not
disturbing what's stacked on them!

--------------------------------------------------------------------
E-Mail: (Ted Harding) <ted.harding at nessie.mcc.ac.uk>
Fax-to-email: +44 (0)870 094 0861
Date: 05-Jun-07                                       Time: 19:35:32
------------------------------ XFMail ------------------------------