Re: Mysql rpm upgrade

Hi,

Andrew.Bridgeman@xxxxxxxxxxxxxx schrieb:


I have been asked to upgrade the Mysql rpm's on one our Redhat version 3
machines and wanted to now the best way of doing this. Should I use the rpm
erase option then the rpm install option or can i just use the upgrade or
Freshen options. Any advice on the best way of doing this would be much
appreciated. If you have done this before what command did you use. The
rpm's I am upgrading too are below.

MySQL-server-community-5.1.22-0.rhel3.i386.rpm
MySQL-client-community-5.1.22-0.rhel3.i386.rpm

I've done two or three LAMP server upgrades from RHEL3/4 -> RHEL4/5 and by this procedure mysql was also updated. An other upgrade was done with a new hardware, so I had only to copy the "old" mysql database files from /var/lib/mysql to the new server.

The only problem I(!) was faced with was the password encryption setting, as this was changed from some version of mysql to the next one.

my.cnf

# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

I don't know why you have to upgrade only mysql as upgrading only one app may breake some other dependecies, so test this good on a test system and make backups ... :-) (and may be installing mysql 5.1 on RHEL3 will not be certified and you will be in trouble if you pay for support)

Regards

--
Götz Reinicke
IT Koordinator

Tel. +49 7141 969 420
Fax +49 7141 969 55 420
E-Mail goetz.reinicke@xxxxxxxxxxxxxxx

Filmakademie Baden-Württemberg GmbH
Mathildenstr. 20
71638 Ludwigsburg
www.filmakademie.de

Eintragung Amtsgericht Stuttgart HRB 205016
Vorsitzender des Aufsichtsrats:
Dr. Christoph Palmer, MdL, Minister a.D.

Geschäftsführer:
Prof. Thomas Schadt

--
redhat-list mailing list
unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe
https://www.redhat.com/mailman/listinfo/redhat-list

Relevant Pages

  • Re: Mysql rpm upgrade
    ... I have been asked to upgrade the Mysql rpm's on one our Redhat version 3 ... I did that, just for the one app. ...
    (RedHat)
  • Re: upgrading mysql client and server
    ... They were installed via ports not packages using custom make options ... I'd rather feed the mysql command a complete file and have it ... This isn't an amazingly difficult upgrade. ... *) Upgrade the MySQL client port and its dependencies first. ...
    (freebsd-questions)
  • Re: Something Broken When I Went To 5.1.2...
    ... I recently did a test upgrade from PHP 4 to 5.1.2 on my Slackware 10.0 ... I also upgraded my MySQL 4 to ... Check 'mysql.default_socket' in your php.ini file, and 'socket' in your my.cnf file. ...
    (comp.lang.php)
  • Re: [kde] about akonadi
    ... Gentoo recently updated from mysql-5.0 to 5.1. ... I think none of the Akonadi developers were aware that MySQL was so ... to the official MySQL upgrade page. ...
    (KDE)
  • Re: An update is needed Fedora!
    ... > Uninstall My current php, mysql and apache packages. ... The upgrading tools will do just that, upgrade from the older versions ... For yum, you can enable the repo temporarily as explained in earlier ...
    (Fedora)