Solution to the failure of MySQL using innobackupex to back up and connect to the server
- 2021-07-03 00:57:33
- OfStack
MySQL failed to connect to the server using innobackupex backup. What should I do?
The error message when using innobackupex backup is as follows:
Failed to connect to MySQL server as DBD::mysql module is not installed at - line 1327.
Cause: perl-based mysql interface tool perl-DBD-MySQL is not installed
Solution:
# perl-DBD-MySQL Whether to install
# yum list installed | grep perl-DBD-MySQL
# View perl-DBD-MySQL Required dependency package
# yum deplist perl-DBD-MySQL.x86_64 | grep mysql
dependency: libmysqlclient.so.16()(64bit)
provider: mysql-libs.x86_64 5.1.71-1.el6
dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit)
provider: mysql-libs.x86_64 5.1.71-1.el6
# Check whether dependency packages exist or are installed on the system
# find / -name libmysqlclient.so.16
/usr/lib64/mysql/libmysqlclient.so.16
# yum list installed | grep mysql-libs.x86_64
mysql-libs.x86_64 5.1.71-1.el6 @anaconda-CentOS-201311272149.x86_64/6.5
# Installation perl-DBD-MySQL
# yum install perl-DBD-MySQL.x86_64
# View
# yum list installed | grep perl-DBD-MySQL
Reference: XTRABACKUP COMPLAINS OF MISSING PERL-DBD-MYSQL