MySQL uses innobackupex backup to connect to the server failed code case

This article mainly introduces in detail MySQL the solution to the failure to connect to the server using innobackupex backup. It has certain reference value. Interested friends can refer to it

MySQL fails to connect to the server using innobackupex backup, what should I do?

When using innobackupex to back up, there is an error message as follows:

Failed to connect to MySQL server as DBD::mysql module is not installed at - line 1327.

Cause: The perl-based mysql interface tool perl-DBD is not installed -MySQL

Solution:

# perl-DBD-MySQL 是否安装 
# yum list installed | grep perl-DBD-MySQL 
 
# 查看 perl-DBD-MySQL 所需依赖包 
# 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 
 
# 查看系统中是否存在或安装了依赖包 
# 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 
 
# 安装 perl-DBD-MySQL 
# yum install perl-DBD-MySQL.x86_64 
 
# 查看 
# yum list installed | grep perl-DBD-MySQL

Reference: XTRABACKUP COMPLAINS OF MISSING PERL-DBD-MYSQL

The above is the detailed content of MySQL uses innobackupex backup to connect to the server failed code case. For more information, please follow other related articles on the PHP Chinese website!