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


Related articles: