Installing XtraBackup on Centos 6

MySQL & MariaDB Percona XtraBackup
1

Hello
I’m trying to install XtraBackup on centos 6 using this guid but i get these errors:

Error: Package: perl-DBD-MySQL-4.013-3.el6.x86_64 (C6.10-base)
Requires: libmysqlclient.so.16()(64bit)
Error: Package: perl-DBD-MySQL-4.013-3.el6.x86_64 (C6.10-base)
Requires: libmysqlclient.so.16(libmysqlclient_16)(64bit)

I searched for the file but i have libmysqlclient.so.18 instead of libmysqlclient.so.16

My mysql version is 5.6

And i’ve already installed libev

please help

2

Hi @Homayoon

The mentioned package is provided by CentOS Vault Mirror

e.g.

Screenshot 2022-11-17 at 15.31.55
Screenshot 2022-11-17 at 15.31.552039×900 151 KB

Screenshot 2022-11-17 at 15.35.15
Screenshot 2022-11-17 at 15.35.152031×587 84 KB

3

Could you please be more specific what needs to be done?

4

You need to Update mirrorlist to the vault for base repo.

e.g.

sed -i 's/mirrorlist/#mirrorlist/g' /etc/yum.repos.d/CentOS-Base.repo
sed -i 's|#baseurl=http://mirror.centos.org|baseurl=http://vault.centos.org|g' /etc/yum.repos.d/CentOS-Base.repo

Screenshot 2022-11-17 at 19.40.13
Screenshot 2022-11-17 at 19.40.132022×404 28.6 KB

5

Thank you for time
It didn’t work same error

Screen Shot 2022-11-18 at 12.09.48
Screen Shot 2022-11-18 at 12.09.481712×682 108 KB

6

Here is my repos

Screen Shot 2022-11-18 at 12.21.46
Screen Shot 2022-11-18 at 12.21.461128×518 112 KB

7

Screen Shot 2022-11-18 at 12.21.27
Screen Shot 2022-11-18 at 12.21.271140×888 177 KB

8

i also changed repos as following link

https://it.megocollector.com/linux/centos-6-end-of-life-repositories/

but same error

9

could you please send me your CentOS-Base.repo content?

10

Could you check what packages are using libmysqlclient.so.18 library in your system?

11

Screenshot 2022-11-18 at 12.35.58
Screenshot 2022-11-18 at 12.35.581222×926 46.8 KB

12

sorry i don’t know how to that

my first problem was getting this error where running sudo yum install percona-xtrabackup-24:

YumRepo Error: All mirror URLs are not using ftp, http[s] or file.

Eg. Invalid release/repo/arch combination/

removing mirrorlist with no valid mirrors: /var/cache/yum/x86_64/6/centos-sclo-sclo/mirrorlist.txt

Error: Cannot find a valid baseurl for repo: centos-sclo-sclo

then i added these to /etc/yum.repos.d/CentOS-Base.repo:

[centos-sclo-rh]
name=CentOS-6.10 - Base
baseurl=http://vault.centos.org/centos/6.9/sclo/$basearch/rh/
gpgcheck=1
enabled=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6

[centos-sclo-sclo]
name=CentOS-6.10 - SCLo sclo
baseurl=http://vault.centos.org/centos/6.9/sclo/$basearch/sclo/
gpgcheck=1
enabled=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6

and even though the rest of CentOS-Base.repo is the same as yours still get Requires: libmysqlclient.so.16()(64bit) error