[NBLUG/talk] How to upgrade MySQL 4 -> 5 on FC4

[Walter Hansen]

Dave Sisley wrote:
> Hey:
> 
> I want to use Groundwork for Nagios on my work machine, which is running 
> a fresh update of Fedora Core 4.  Unfortunately, Groundwork requires 
> MySQL 5.0.16 or higher.  Specifically, Groundwork wants the *-client, 
> *-server  and *-shared-compat packages for MySQL.
> 
> My machine is running the following:
> 
>    mysql-devel-4.1.16-1.FC4.1
>    mysql-4.1.16-1.FC4.1
>    php-mysql-5.0.4-10.5
>    mysql-server-4.1.16-1.FC4.1
> 
> I'm looking for suggestion as to how to upgrade.  Sadly, it's not as 
> easy as 'yum update mysql' - I already have the latest available 
> versions for my repositories and FC4 ships with MySQL4, not 5.  I have 
> downloaded the dynamically linked RPMs from MySQL's mirrors, but get 
> wierd errors when I try to 'yum localupdate...' them.  The latest error 
> looks like this:
> 
>    Package MySQL-server not installed, cannot update it. Run yum
>    install to install it instead.
> 
> Is that because I have 'mysql-server' installed, not 'MySQL-server'?  Do 
> I need to change the name of the new package?  It feels more likely that 
> I will need to remove the old packages (yum remove ...) and then install 
> the new ones (yum localinstall...).
> 
> A last option would be to upgrade one more time to FC5, but I would 
> rather not.  Can anyone recommend a method for upgrading MySQL?  I smell 
> disaster if I just plow ahead like I usually do -- Help me save me from 
> myself!
> 
> Thanks,
> 
> -dave.
> 


This may be the total novice in me, but why not just uninstall the RPM 
and install 5 from source. Offhand I don't remember it having unusual 
dependencies, but I could be wrong.