[MySQL] CentOS7安装percona-xtrabackup时/etc/my.cnf冲突报错解决

环境:
CentOS7.3 + mysql-community-5.7

[root@mysql-02 ~]# cat /etc/redhat-release
CentOS Linux release 7.3.1611 (Core)
[root@mysql-lh02 ~]# rpm -qa | grep -i mysql
perl-DBD-MySQL-4.023-5.el7.x86_64
mysql-community-client-5.7.19-1.el7.x86_64
mysql-community-libs-compat-5.7.19-1.el7.x86_64
mysql-community-common-5.7.19-1.el7.x86_64
mysql-community-server-5.7.19-1.el7.x86_64
[root@mysql-02 ~]#


安装percona-xtrabackup时冲突报错

[root@mysql-02 ~]# yum install http://www.percona.com/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm
[root@mysql-lh02 ~]# yum list | grep percona-xtrabackup
percona-xtrabackup.x86_64                   2.3.9-1.el7                percona-release-x86_64
percona-xtrabackup-22.x86_64                2.2.13-1.el7               percona-release-x86_64
percona-xtrabackup-22-debuginfo.x86_64      2.2.13-1.el7               percona-release-x86_64
percona-xtrabackup-24.x86_64                2.4.8-1.el7                percona-release-x86_64
percona-xtrabackup-24-debuginfo.x86_64      2.4.8-1.el7                percona-release-x86_64
percona-xtrabackup-debuginfo.x86_64         2.3.9-1.el7                percona-release-x86_64
percona-xtrabackup-test.x86_64              2.3.9-1.el7                percona-release-x86_64
percona-xtrabackup-test-22.x86_64           2.2.13-1.el7               percona-release-x86_64
percona-xtrabackup-test-24.x86_64           2.4.8-1.el7                percona-release-x86_64
[root@mysql-02 ~]# yum install percona-xtrabackup-24
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
Resolving Dependencies
--> Running transaction check
---> Package percona-xtrabackup-24.x86_64 0:2.4.8-1.el7 will be installed
--> Processing Dependency: perl(DBD::mysql) for package: percona-xtrabackup-24-2.4.8-1.el7.x86_64
--> Processing Dependency: libev.so.4()(64bit) for package: percona-xtrabackup-24-2.4.8-1.el7.x86_64
--> Running transaction check
---> Package libev.x86_64 0:4.15-7.el7 will be installed
---> Package perl-DBD-MySQL.x86_64 0:4.023-5.el7 will be installed
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: perl-DBD-MySQL-4.023-5.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: perl-DBD-MySQL-4.023-5.el7.x86_64
--> Running transaction check
---> Package Percona-Server-shared-56.x86_64 0:5.6.37-rel82.2.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=============================================================================================
 Package                     Arch      Version               Repository                 Size
=============================================================================================
Installing:
 percona-xtrabackup-24       x86_64    2.4.8-1.el7           percona-release-x86_64    7.4 M
Installing for dependencies:
 Percona-Server-shared-56    x86_64    5.6.37-rel82.2.el7    percona-release-x86_64    618 k
 libev                       x86_64    4.15-7.el7            extras                     44 k
 perl-DBD-MySQL              x86_64    4.023-5.el7           base                      140 k

Transaction Summary
=============================================================================================
Install  1 Package (+3 Dependent packages)

Total download size: 8.1 M
Installed size: 35 M
Is this ok [y/d/N]: y
Downloading packages:
(1/4): libev-4.15-7.el7.x86_64.rpm                                    |  44 kB  00:00:02    
(2/4): perl-DBD-MySQL-4.023-5.el7.x86_64.rpm                          | 140 kB  00:00:02    
warning: /var/cache/yum/x86_64/7/percona-release-x86_64/packages/Percona-Server-shared-56-5.6.37-rel82.2.el7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Public key for Percona-Server-shared-56-5.6.37-rel82.2.el7.x86_64.rpm is not installed
(3/4): Percona-Server-shared-56-5.6.37-rel82.2.el7.x86_64.rpm         | 618 kB  00:00:05    
(4/4): percona-xtrabackup-24-2.4.8-1.el7.x86_64.rpm                   | 7.4 MB  00:00:33    
---------------------------------------------------------------------------------------------
Total                                                        250 kB/s | 8.1 MB  00:00:33    
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-Percona
Importing GPG key 0xCD2EFD2A:
 Userid     : "Percona MySQL Development Team <mysql-dev@percona.com>"
 Fingerprint: 430b df5c 56e7 c94e 848e e60c 1c4c bdcd cd2e fd2a
 Package    : percona-release-0.1-4.noarch (installed)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-Percona
Is this ok [y/N]: y
Running transaction check
Running transaction test


Transaction check error:
  file /etc/my.cnf from install of Percona-Server-shared-56-5.6.37-rel82.2.el7.x86_64 conflicts with file from package mysql-community-server-5.7.19-1.el7.x86_64

Error Summary
-------------

[root@mysql-02 ~]#


解决办法:

补充安装

[root@mysql-02 ~]# rpm -ivh mysql-community-libs-compat-5.7.19-1.el7.x86_64.rpm
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-libs-compat-5.7.1################################# [100%]
[root@mysql-02 ~]#

然后再次安装percona-xtrabackup成功

[root@mysql-02 ~]# yum install percona-xtrabackup-24
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
Resolving Dependencies
--> Running transaction check
---> Package percona-xtrabackup-24.x86_64 0:2.4.8-1.el7 will be installed
--> Processing Dependency: perl(DBD::mysql) for package: percona-xtrabackup-24-2.4.8-1.el7.x86
--> Processing Dependency: libev.so.4()(64bit) for package: percona-xtrabackup-24-2.4.8-1.el7._64
--> Running transaction check
---> Package libev.x86_64 0:4.15-7.el7 will be installed
---> Package perl-DBD-MySQL.x86_64 0:4.023-5.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==============================================================================================
 Package                     Arch         Version             Repository                    Si
==============================================================================================
Installing:
 percona-xtrabackup-24       x86_64       2.4.8-1.el7         percona-release-x86_64       7.4
Installing for dependencies:
 libev                       x86_64       4.15-7.el7          extras                        44
 perl-DBD-MySQL              x86_64       4.023-5.el7         base                         140

Transaction Summary
==============================================================================================
Install  1 Package (+2 Dependent packages)

Total size: 7.5 M
Installed size: 31 M
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
** Found 3 pre-existing rpmdb problem(s), 'yum check' output follows:
ipa-client-4.4.0-12.el7.centos.x86_64 has installed conflicts freeipa-client: ipa-client-4.4.0.el7.centos.x86_64
ipa-client-common-4.4.0-12.el7.centos.noarch has installed conflicts freeipa-client-common: iplient-common-4.4.0-12.el7.centos.noarch
ipa-common-4.4.0-12.el7.centos.noarch has installed conflicts freeipa-common: ipa-common-4.4.0.el7.centos.noarch
  Installing : libev-4.15-7.el7.x86_64                                                       1
  Installing : perl-DBD-MySQL-4.023-5.el7.x86_64                                             2
  Installing : percona-xtrabackup-24-2.4.8-1.el7.x86_64                                      3
  Verifying  : perl-DBD-MySQL-4.023-5.el7.x86_64                                             1
  Verifying  : percona-xtrabackup-24-2.4.8-1.el7.x86_64                                      2
  Verifying  : libev-4.15-7.el7.x86_64                                                       3

Installed:
  percona-xtrabackup-24.x86_64 0:2.4.8-1.el7                                                 

Dependency Installed:
  libev.x86_64 0:4.15-7.el7                  perl-DBD-MySQL.x86_64 0:4.023-5.el7             

Complete!
[root@mysql-02 ~]#

 

已标记关键词 清除标记
--> 正在处理依赖关系 libwx_gtk2u_aui-2.8.so.0(WXU_2.8)(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_adv-2.8.so.0(WXU_2.8)(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_stc-2.8.so.0(WXU_2.8)(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_xrc-2.8.so.0(WXU_2.8)(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_html-2.8.so.0(WXU_2.8)(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_aui-2.8.so.0(WXU_2.8.5)(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_baseu-2.8.so.0(WXU_2.8)(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_gl-2.8.so.0(WXU_2.8)(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_core-2.8.so.0(WXU_2.8.10)(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_core-2.8.so.0(WXU_2.8)(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_xrc-2.8.so.0()(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_html-2.8.so.0()(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_adv-2.8.so.0()(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_baseu_xml-2.8.so.0()(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_gl-2.8.so.0()(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_baseu-2.8.so.0()(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_stc-2.8.so.0()(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_aui-2.8.so.0()(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_core-2.8.so.0()(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 ---> 软件包 erlang-xmerl.x86_64.0.20.0rc1-3.el7.centos 将被 安装 --> 正在检查事务 ---> 软件包 erlang-wx.x86_64.0.20.0rc1-3.el7.centos 将被 安装 --> 正在处理依赖关系 libwx_gtk2u_aui-2.8.so.0(WXU_2.8)(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_adv-2.8.so.0(WXU_2.8)(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_stc-2.8.so.0(WXU_2.8)(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_xrc-2.8.so.0(WXU_2.8)(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_html-2.8.so.0(WXU_2.8)(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_aui-2.8.so.0(WXU_2.8.5)(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_baseu-2.8.so.0(WXU_2.8)(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_gl-2.8.so.0(WXU_2.8)(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_core-2.8.so.0(WXU_2.8.10)(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_core-2.8.so.0(WXU_2.8)(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_xrc-2.8.so.0()(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_html-2.8.so.0()(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_adv-2.8.so.0()(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_baseu_xml-2.8.so.0()(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_gl-2.8.so.0()(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_baseu-2.8.so.0()(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_stc-2.8.so.0()(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_aui-2.8.so.0()(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 --> 正在处理依赖关系 libwx_gtk2u_core-2.8.so.0()(64bit),它被软件包 erlang-wx-20.0rc1-3.el7.centos.x86_64 需要 ---> 软件包 unixODBC.x86_64.0.2.3.1-11.el7 将被 安装 --> 解决依赖关系完成 错误:软件包:erlang-wx-20.0rc1-3.el7.centos.x86_64 (erlang-solutions) 需要:libwx_gtk2u_gl-2.8.so.0()(64bit) 错误:软件包:erlang-wx-20.0rc1-3.el7.centos.x86_64 (erlang-solutions) 需要:libwx_gtk2u_core-2.8.so.0(WXU_2.8.10)(64bit) 错误:软件包:erlang-wx-20.0rc1-3.el7.centos.x86_64 (erlang-solutions) 需要:libwx_gtk2u_adv-2.8.so.0()(64bit) 错误:软件包:erlang-wx-20.0rc1-3.el7.centos.x86_64 (erlang-solutions) 需要:libwx_gtk2u_stc-2.8.so.0(WXU_2.8)(64bit) 错误:软件包:erlang-wx-20.0rc1-3.el7.centos.x86_64 (erlang-solutions) 需要:libwx_gtk2u_adv-2.8.so.0(WXU_2.8)(64bit) 错误:软件包:erlang-wx-20.0rc1-3.el7.centos.x86_64 (erlang-solutions) 需要:libwx_baseu_xml-2.8.so.0()(64bit) 错误:软件包:erlang-wx-20.0rc1-3.el7.centos.x86_64 (erlang-solutions) 需要:libwx_gtk2u_html-2.8.so.0()(64bit) 错误:软件包:erlang-wx-20.0rc1-3.el7.centos.x86_64 (erlang-solutions) 需要:libwx_gtk2u_core-2.8.so.0()(64bit) 错误:软件包:erlang-wx-20.0rc1-3.el7.centos.x86_64 (erlang-solutions) 需要:libwx_gtk2u_xrc-2.8.so.0(WXU_2.8)(64bit) 错误:软件包:erlang-wx-20.0rc1-3.el7.centos.x86_64 (erlang-solutions) 需要:libwx_gtk2u_core-2.8.so.0(WXU_2.8)(64bit) 错误:软件包:erlang-wx-20.0rc1-3.el7.centos.x86_64 (erlang-solutions) 需要:libwx_gtk2u_aui-2.8.so.0(WXU_2.8.5)(64bit) 错误:软件包:erlang-wx-20.0rc1-3.el7.centos.x86_64 (erlang-solutions) 需要:libwx_gtk2u_aui-2.8.so.0()(64bit) 错误:软件包:erlang-wx-20.0rc1-3.el7.centos.x86_64 (erlang-solutions) 需要:libwx_gtk2u_xrc-2.8.so.0()(64bit) 错误:软件包:erlang-wx-20.0rc1-3.el7.centos.x86_64 (erlang-solutions) 需要:libwx_baseu-2.8.so.0(WXU_2.8)(64bit) 错误:软件包:erlang-wx-20.0rc1-3.el7.centos.x86_64 (erlang-solutions) 需要:libwx_gtk2u_aui-2.8.so.0(WXU_2.8)(64bit) 错误:软件包:erlang-wx-20.0rc1-3.el7.centos.x86_64 (erlang-solutions) 需要:libwx_gtk2u_stc-2.8.so.0()(64bit) 错误:软件包:erlang-wx-20.0rc1-3.el7.centos.x86_64 (erlang-solutions) 需要:libwx_baseu-2.8.so.0()(64bit) 错误:软件包:erlang-wx-20.0rc1-3.el7.centos.x86_64 (erlang-solutions) 需要:libwx_gtk2u_gl-2.8.so.0(WXU_2.8)(64bit) 错误:软件包:erlang-wx-20.0rc1-3.el7.centos.x86_64 (erlang-solutions) 需要:libwx_gtk2u_html-2.8.so.0(WXU_2.8)(64bit) 您可以尝试添加 --skip-broken 选项来解决该问题 ** 发现 8 个已存在的 RPM 数据库问题, 'yum check' 输出如下: icedtea-web-1.6.2-4.el7.x86_64 有缺少的需求 java-1.8.0-openjdk ipa-client-4.4.0-12.el7.centos.x86_64 有已安装冲突 freeipa-client: ipa-client-4.4.0-12.el7.centos.x86_64 ipa-client-common-4.4.0-12.el7.centos.noarch 有已安装冲突 freeipa-client-common: ipa-client-common-4.4.0-12.el7.centos.noarch ipa-common-4.4.0-12.el7.centos.noarch 有已安装冲突 freeipa-common: ipa-common-4.4.0-12.el7.centos.noarch javapackages-tools-3.4.1-11.el7.noarch 有缺少的需求 python-javapackages = ('0', '3.4.1', '11.el7') jline-1.0-8.el7.noarch 有缺少的需求 java >= ('0', '1.5', None) 1:libreoffice-core-5.0.6.2-3.el7.x86_64 有缺少的需求 java-headless >= ('1', '1.6', None) 1:libreoffice-ure-5.0.6.2-3.el7.x86_64 有缺少的需求 libjvm.so()(64bit)
©️2020 CSDN 皮肤主题: 深蓝海洋 设计师:CSDN官方博客 返回首页