Re: Upgrading MySQL from 4.1 to 5

["Tito Valentin" <daemonracing@xxxxxxxxx>]

If I am going to run "rpm -Uvh" then why would I need to remove the current mysql server?  If I remove the current mysql, shouldn't I run "rpm -ivh" instead?



Thanks for the help so far.

On Tue, Apr 15, 2008 at 6:24 PM, Morten Nilsen <morten@xxxxxxxxxx> wrote:

Tito Valentin wrote:

I am trying to upgrade MySQL on CentOS 4.5 but having a hard time.  I need to go from MySQL 4.1 to 5.  I downloaded the following two files:

mysql-server-5.0.58-1.el4.centos.i386.rpm
mysql-5.0.48-2.el4.centos.i386.rpm

I tried to do:

yum install mysql-server-5.0.58-1.el4.centos.i386.rpm

The command to use here would be rpm -Uvh, as these packages are not in the yum system.

You would need to uninstall the current mysql first, however - and to migrate any data, you need to use mysqldump --all --opt before that, and then import it back after 5.x is installed.

Last time I checked, you could not use the same database files for different major versions of MySQL - I could be wrong on this point, however.

--
Cheers,
Morten
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos

_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos