Upgrade to mysql 4.1.18 in 5 minutes

[simonp@]

Hi,

I have been looking in so many places for how o upgrade the poor old mysql to something more recent. I found little bits every where and no luck and then just did it myself which was quite easy.

The biggest issues is the number of dependancies on mysql from plesk etc. So atomicrocketturtle aka ART is the man that makes this a breeze! So for my Fedora Core 3 (will most likely work for others) do the following:

1. Get list of repositories wanting to add
eg: http://3es.atomicrocketturtle.com/packages/mysql/_buildlogs/

2. Select the ones that apply
eg:
[atomic]
name=Atomic Rocket Turtle - $releasever - Atomic PSA-Compatible RPMS
baseurl=http://3es.atomicrocketturtle.com/atomic/art/$releasever/

[atomic-app-vault]
name=Atomic Rocket Turtle - $releasever - Atomic PSA App Vault RPMS
baseurl=http://3es.atomicrocketturtle.com/atomic/app-vault/

[psa-7.5]
name=Atomic Rocket Turtle - $releasever - SW-Soft PSA 7.5 RPMS
baseurl=http://3es.atomicrocketturtle.com/atomic/psa-7.5/$releasever/

[base]
name=Atomic Rocket Turtle - $releasever - Base OS RPMS mirror
baseurl=http://3es.atomicrocketturtle.com/3rd-party/base/$releasever/

[updates]
name=Atomic Rocket Turtle - $releasever - OS Update RPMS mirror
baseurl=http://3es.atomicrocketturtle.com/3rd-party/updates/$releasever/

3. Create repository file in ‘/etc/yum.repos.d’
eg: fedora-atomicrocketturtle.repo – should have .repo extension!

4. Add the resposotries wanting to add (from above) to this file

5. To check it is working do a YUM info list – this will go through all repositories and show it if works or not
Eg: yum info mysql

6. Get yum to install mysql4.1.18 for you
-> yum install mysql
and enter Y at the prompt

This was amazing - in a few minutes I have it up and running and it even moved all my dbs to the new version where now I can use the simple things like UNION in my sql statements!

Cool & enjoy!

Simon

 

[Highland]

Just a small note...

If you're going from 3.x or 4.0.x to 4.1.x then you need to add the following line to your my.cnf file under [mysqld]

old_passwords=1

If you don't you may find your applications get their passwords upgraded and no longer work.

 

[simonp@]

Hi,

Thanks for adding that important note to this list.

Strange (but true) it seemed that I didn't have to do that. I am not sure if that was built into the RPM (doubt it?!?). Lucky!

It looks pretty complete now and I hope someone finds it of use.

Thanks

Simon

 

[criticman]

It was built in to the RPM. I had to copy the new my.cnf.rpmnew to my.cnf and saved the old one just in case, but that was it.

So far, all seems to be fine (knock on wood).

Thanks again to Art!

 

[bonesadams]

I tried to update mysql . it gave me :

(1/10): mysql-4.1.18-1.rh 100% 00:03
(2/10): php-mbstring-4.4. 100% 00:01
(3/10): php-imap-4.4.2-3. 100% 00:00
(4/10): php-pgsql-4.4.2-3 100% 00:00
(5/10): php-mysql-4.4.2-3 100% 00:00
(6/10): php-pear-4.4.2-3. 100% 00:00
(7/10): mysql-server-4.1. 100% 00:07
(8/10): mysql-compat-4.1. 100% 00:00
(9/10): php-4.4.2-3.rhfc3 100% 00:03
(10/10): php-domxml-4.4.2 100% 00:00

when I rebooted the server it never came back