Upgrading MySQL 3

[dlevancho]

has anyone tried upgrading MySQLserver? from 3.23.58?

[retep]

Yes, it has been done before. You may want to try this howto: http://rimuhosting.com/howto/mysqlinstall.jsp

[emobus]

That's a great FAQ that you've put together. There's a tiny issue with it now that the most current mysql version is 4.1.13 not 4.1.12

I set $VERSION to 4.1.13 and it looked for the file:
MySQL-client-4.1.13-1.i386.rpm

But it's not 4.1.13-1 it's 4.1.13-0!

So I had to change the 1s for 0s in 6 places in the script.

wget --quiet "http://mysql.mirrors.pair.com/Downloads/MySQL-4.1/MySQL-client-$VERSION-0.i386.rpm"

Maybe an update of the script is required with a $VERSION_MINOR variable?



Anyway, this took me about 2 mins to work out and otherwise the upgrade went very smoothly indeed. Thanks for making it nice and easy for me...!

Cheers,
Dave

[retep]

Hi. I had been bit by this once or twice as well. Your solution is a nice one. The website will include if after the next code push. Thanks!

[di1b3rt]

I'm also having some problems w/ the upgrade. I'll post my system information first.

[root@]# uname -a
Linux 2.4.27rimu1-3um #1 Thu Sep 9 02:48:08 UTC 2004 i686 i686 i386 GNU/Linux

[root@]# rpm -qa | grep mysql
libdbi-dbd-mysql-0.6.5-5
mysql-3.23.58-15.RHEL3.1
mysql-devel-3.23.58-15.RHEL3.1
mysql-server-3.23.58-15.RHEL3.1
php-mysql-4.3.2-23.ent

=====

When I attempt to run the script provided I get the following output errors:
[root@]# ./mysql-upgrade.sh
./mysql-upgrade.sh: line 22: /etc/rc.d/init.d/mysql: No such file or directory
Stopping MySQL: [FAILED]
warning: MySQL-client-4.1.12-1.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.1021-3
libmysqlclient.so.10 is needed by (installed) libdbi-dbd-mysql-0.6.5-5
libmysqlclient.so.10 is needed by (installed) MySQL-python-0.9.1-6
libmysqlclient.so.10 is needed by (installed) php-mysql-4.3.2-23.ent
Mysql rpms did not install

=========

steps I've taken so far:
Following the advice from the above post I changed the version to be more up to date (subversion variable isn't necessary if you just add it to the version and delete off the appending -1). Modified the script to not attempt to install the client. Modified the repository. Confirmed that the -f is there for RPM.

I didn't try nodeps since I'm not sure what they'll do and don't want to make the system too unstable and have to ask for a reinstall.

I'm still working on doing this upgrade and will post back any progess. If anyone has any hints or places I can look to make things go by faster it would be much appreciated.

[retep]

If you're still stuck, pop in a support ticket and we can help.

[di1b3rt]

w00t... upgraded.

modifications to the script:

VERSION=4.1.13-0.rhel3.i386

.....

wget --quiet "http://mysql.mirrors.pair.com/Downloads/MySQL-4.1/MySQL-client-standard-$VERSION.rpm"
if [ $? -ne 0 ]; then
echo "File http://mysql.mirrors.pair.com/Downloads/MySQL-4.1/MySQL-client-standard-$VERSION.rpm not found." >&2
return 1
fi

.....

wget "http://mysql.mirrors.pair.com/Downloads/MySQL-4.1/MySQL-shared-compat-$VERSION.rpm"
wget "http://mysql.mirrors.pair.com/Downloads/MySQL-4.1/MySQL-devel-standard-$VERSION.rpm"
wget "http://mysql.mirrors.pair.com/Downloads/MySQL-4.1/MySQL-server-standard-$VERSION.rpm"

===============================

If you don't have the compat version of the shared rpm (aka you were using standard instead like this fool) you'll get a dependancy failure for libmysqlclient.so.10.

As a side benefit this upgrade also resolves the the error concerning 'interactive_timeout=100000' when attempting to connect from OS X client to the server using the query builder gui.