Can't upgrade MySQL on Fedora Core 6

vman_nn1 · 02-05-2008, 07:16 AM

I've been trying to upgrade mysql 5.0.27 to mysql 5.0.45 (have also tried 5.0.51a) using yum localinstall, but I keep having trouble with dependency troubles.

I've tried using the rpm packages from dev.mysql.com but keep getting the following:

Code:

[root@localhost ~]# yum localupdate mysql-client-5.0.51a-0.i386.rpm MySQL-server-5.0.51a-0.i386.rpm
Setting up Local Package Process
Examining mysql-client-5.0.51a-0.i386.rpm: MySQL-client - 5.0.51a-0.i386
Package MySQL-client not installed, cannot update it. Run yum install to install it instead.
Examining MySQL-server-5.0.51a-0.i386.rpm: MySQL-server - 5.0.51a-0.i386
Package MySQL-server not installed, cannot update it. Run yum install to install it instead.
Nothing to do

i don't understand why yum isn't associating the rpm files with current installed version of mysql. From what I've read in the MySQL reference manual, the rpms they provide are Generic RPM's and should work on any linux distribution.

I've also tried using the rpms from:

ftp://ftp.pbone.net/mirror/remi.coll.../rpms/fc6.i386

At first I recieved lots of dependency errors to do with libmysqlclient_15 which I resolved by installing the MySQL-shared-compat rpm. Afterwards here's what I got:

Code:

[root@localhost ~]# yum localinstall mysql-5.0.45-1.fc6.remi.i386.rpm mysql-server-5.0.45-1.fc6.remi.i386.rpm
Setting up Local Package Process
Examining mysql-5.0.45-1.fc6.remi.i386.rpm: mysql - 5.0.45-1.fc6.remi.i386
Examining mysql-server-5.0.45-1.fc6.remi.i386.rpm: mysql-server - 5.0.45-1.fc6.remi.i386
Marking mysql-5.0.45-1.fc6.remi.i386.rpm as an update to mysql - 5.0.27-1.fc6.i386
Marking mysql-server-5.0.45-1.fc6.remi.i386.rpm as an update to mysql-server - 5.0.27-1.fc6.i386
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package mysql.i386 0:5.0.45-1.fc6.remi set to be updated
---> Package mysql-server.i386 0:5.0.45-1.fc6.remi set to be updated
--> Running transaction check
Setting up repositories
Reading repository metadata in from local files
Excluding Packages in global exclude list
Finished
--> Processing Dependency: mysql-libs = 5.0.45-1.fc6.remi for package: mysql
--> Finished Dependency Resolution
Error: Missing Dependency: mysql-libs = 5.0.45-1.fc6.remi is needed by package mysql

ok so I need to install the mysql-libs package; I downloaded this from the same place at rpm.pbone.net, I go to install mysql-libs and get the following:

Code:

[root@localhost ~]# yum localinstall mysql-libs-5.0.45-1.fc6.remi.i386.rpm
Setting up Local Package Process
Examining mysql-libs-5.0.45-1.fc6.remi.i386.rpm: mysql-libs - 5.0.45-1.fc6.remi.i386
Marking mysql-libs-5.0.45-1.fc6.remi.i386.rpm to be installed
Setting up repositories
Reading repository metadata in from local files
Excluding Packages in global exclude list
Finished
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package mysql-libs.i386 0:5.0.45-1.fc6.remi set to be updated
--> Running transaction check

Dependencies Resolved

=============================================================================
 Package                 Arch       Version          Repository        Size
=============================================================================
Installing:
 mysql-libs              i386       5.0.45-1.fc6.remi  mysql-libs-5.0.45-1.fc6.remi.i386.rpm  3.6 M

Transaction Summary
=============================================================================
Install      1 Package(s)
Update       0 Package(s)
Remove       0 Package(s)

Total download size: 3.6 M
Is this ok [y/N]: y
Downloading Packages:
Running Transaction Test
Finished Transaction Test


Transaction Check Error:   file /etc/my.cnf from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/lib/mysql/libmysqlclient.so.15.0.0 from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/lib/mysql/libmysqlclient_r.so.15.0.0 from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/charsets/Index.xml from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/charsets/armscii8.xml from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/charsets/ascii.xml from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/charsets/cp1250.xml from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/charsets/cp1251.xml from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/charsets/cp1256.xml from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/charsets/cp1257.xml from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/charsets/cp850.xml from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/charsets/cp852.xml from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/charsets/cp866.xml from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/charsets/dec8.xml from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/charsets/geostd8.xml from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/charsets/greek.xml from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/charsets/hebrew.xml from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/charsets/hp8.xml from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/charsets/keybcs2.xml from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/charsets/koi8r.xml from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/charsets/koi8u.xml from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/charsets/latin1.xml from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/charsets/latin2.xml from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/charsets/latin5.xml from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/charsets/latin7.xml from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/charsets/macce.xml from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/charsets/macroman.xml from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/charsets/swe7.xml from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/czech/errmsg.sys from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/danish/errmsg.sys from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/dutch/errmsg.sys from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/english/errmsg.sys from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/estonian/errmsg.sys from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/french/errmsg.sys from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/german/errmsg.sys from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/greek/errmsg.sys from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/hungarian/errmsg.sys from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/italian/errmsg.sys from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/japanese/errmsg.sys from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/korean/errmsg.sys from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/norwegian-ny/errmsg.sys from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/norwegian/errmsg.sys from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/polish/errmsg.sys from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/portuguese/errmsg.sys from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/romanian/errmsg.sys from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/russian/errmsg.sys from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/serbian/errmsg.sys from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/slovak/errmsg.sys from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/spanish/errmsg.sys from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/swedish/errmsg.sys from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6
  file /usr/share/mysql/ukrainian/errmsg.sys from install of mysql-libs-5.0.45-1.fc6.remi conflicts with file from package mysql-5.0.27-1.fc6

ok so the mysql-libs package looks like its trying to overwrite some already installed files which are a part of the current installed version of mysql.

Wow ok, I'm stuck now and need help, anybody please!!!

waelaltaqi · 02-05-2008, 07:49 AM

have you tried yum update instead of yum localupdate

Another sugestion is to download the rpm packages static and try installing them using rpm -Uvh command

vman_nn1 · 02-05-2008, 11:06 AM

Quote:

Originally Posted by waelaltaqi

have you tried yum update instead of yum localupdate

Another sugestion is to download the rpm packages static and try installing them using rpm -Uvh command

i've tried using yum update, it says i have the latest version. I've never used rpm -Uvh as I was afraid of messing up my system, does it actually update mysql (like yum) and also update all the dependencies?

reddazz · 02-05-2008, 11:40 AM

I doubt that you can just upgrade the Fedora mysql packages using third pary rpms without experiencing some sort of problem. I think your best bet is to uninstall the Fedora mysql packages using yum or rpm and then install the packages you downloaded from the mysql site afterwards.