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!