升级 MySQL 导致错误

升级 MySQL 导致错误

我正在运行 Centos 5.8(x86_64 上的 Linux 2.6.18-308.13.1.el5),并希望升级 MySQL 版本 5.0.95。我正在使用以下教程:http://www.if-not-true-then-false.com/2010/install-mysql-on-fedora-centos-red-hat-rhel/。当我看到以下内容时,我得到了大量错误。似乎与从 386 到 86x64 有关。有人能帮忙吗?谢谢

yum --enablerepo=remi,remi-test update mysql mysql-server

Transaction Check Error:   file /etc/my.cnf from install of
mysql50-5.0.96-2.ius.el5.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/info/mysql.info.gz from
install of mysql50-5.0.96-2.ius.el5.x86_64 conflicts with file from
package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/man/man1/mysql.1.gz from install of
mysql50-5.0.96-2.ius.el5.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/man/man1/mysqlaccess.1.gz from install of
mysql50-5.0.96-2.ius.el5.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/man/man1/mysqladmin.1.gz
from install of mysql50-5.0.96-2.ius.el5.x86_64 conflicts with file
from package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/man/man1/mysqldump.1.gz from install of
mysql50-5.0.96-2.ius.el5.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/man/man1/mysqlshow.1.gz
from install of mysql50-5.0.96-2.ius.el5.x86_64 conflicts with file
from package mysql-5.0.95-1.el5_7.1.i386   file /etc/my.cnf from
install of mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file
from package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/charsets/Index.xml from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/charsets/cp1250.xml from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/charsets/cp1251.xml from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/mysql/czech/errmsg.sys
from install of mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with
file from package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/danish/errmsg.sys from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/mysql/dutch/errmsg.sys
from install of mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with
file from package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/english/errmsg.sys from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/estonian/errmsg.sys from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/mysql/french/errmsg.sys
from install of mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with
file from package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/german/errmsg.sys from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/mysql/greek/errmsg.sys
from install of mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with
file from package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/hungarian/errmsg.sys from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/mysql/italian/errmsg.sys
from install of mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with
file from package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/japanese/errmsg.sys from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/mysql/korean/errmsg.sys
from install of mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with
file from package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/norwegian-ny/errmsg.sys from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/norwegian/errmsg.sys from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/mysql/polish/errmsg.sys
from install of mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with
file from package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/portuguese/errmsg.sys from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/romanian/errmsg.sys from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/mysql/russian/errmsg.sys
from install of mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with
file from package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/serbian/errmsg.sys from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/mysql/slovak/errmsg.sys
from install of mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with
file from package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/spanish/errmsg.sys from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/mysql/swedish/errmsg.sys
from install of mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with
file from package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/ukrainian/errmsg.sys from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/bin/mysqlaccess from install
of mysql-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/man/man1/my_print_defaults.1.gz from install of
mysql-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/man/man1/mysql.1.gz from
install of mysql-5.5.28-1.el5.remi.x86_64 conflicts with file from
package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/man/man1/mysql_config.1.gz from install of
mysql-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/man/man1/mysql_find_rows.1.gz from install of
mysql-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/man/man1/mysql_waitpid.1.gz from install of
mysql-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/man/man1/mysqlaccess.1.gz from install of
mysql-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/man/man1/mysqladmin.1.gz
from install of mysql-5.5.28-1.el5.remi.x86_64 conflicts with file
from package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/man/man1/mysqldump.1.gz from install of
mysql-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/man/man1/mysqlshow.1.gz
from install of mysql-5.5.28-1.el5.remi.x86_64 conflicts with file
from package mysql-5.0.95-1.el5_7.1.i386

答案1

看起来您使用了 IUS 社区存储库中的 MySQL 包。遗憾的是,这些包似乎与原始包并不 100% 兼容,因此您会得到像这样的损坏的依赖关系。首先删除所有现有的 MySQL 包(您的数据库不会受到影响),然后安装 remi 存储库中的包(这些包兼容且没有依赖关系问题)。

您还需要确保已禁用或删除了冲突的 repo(IUS)。

答案2

从输出结果来看,它试图在旧版本的同时安装新版本的 mysql,而不是真正地升级。这可能是因为你试图安装 x86_64 版本,但之前你使用的是 i386 版本(我认为这要么是 yum 中的错误,要么是你使用的存储库中的错误,事实上这是错误报告)。

尝试明确指定 i386 版本的 mysql,或者使用 mysqldump 转储整个实例,卸载,然后安装 x86_64 版本并导入转储(您可以通过将 mysqldump 获取的转储通过管道传输到 来导入它们mysql -p,因为它们是 SQL 脚本)。

要专门更新 i386 版本,请将mysql mysql-server命令更改为mysql.i386 mysql-server.i386

相关内容