Solution to the failure of MySQL to use innobackupex to backup the connection server

What should I do if MySQL fails to connect to the server using innobackupex to back up?

When using innobackupex to back up, the error message is as follows:
Failed to connect to MySQL server as DBD::mysql module is not installed at - line 1327.

Reason: The Perl-DBD-MySQL interface tool based on Perl is not installed

Solution:

# Is perl-DBD-MySQL installed? # yum list installed | grep perl-DBD-MySQL 
 
# View the required dependency packages of 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 
 
# Check whether the dependent package exists or is installed in 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 
 
# Install 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

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.

You may also be interested in:

Solution to the problem of mysql service starting but not connecting
Detailed explanation of performance monitoring of MySQL server using Prometheus and Grafana
Mysql5.7 service cannot be started. Graphical solution tutorial
Solution to the problem that the service name is invalid when running mysql net start
MySQL uses show status to view MySQL server status information
The best way to automatically backup the mysql database (windows server)
How to view the path of the MySQL configuration file on the Linux server
Solution to MySql service disappearance for unknown reasons

<<: Comprehensive analysis of prototypes, prototype objects, and prototype chains in js

>>: How to redirect to https through nginx load balancing