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

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

Recommend

Solution to the problem that the image name is none after Docker load

Recently, I found that after using the docker loa...

vue-cropper plug-in realizes the encapsulation of image capture and upload component

The specific code for encapsulating the image cap...

How to turn a jar package into a docker container

How to turn a jar package into a docker container...

Three ways to delete a table in MySQL (summary)

drop table Drop directly deletes table informatio...

The difference between the four file extensions .html, .htm, .shtml and .shtm

Many friends who have just started to make web pag...

Summary of CSS gradient effects (linear-gradient and radial-gradient)

Linear-gradient background-image: linear-gradient...

Sample code for CSS image animation effects (photo frame)

This article introduces the sample code of CSS pi...

How to detect Ubuntu version using command line

Method 1: Use the lsb_release utility The lsb_rel...

User-centered design

I've been asked a lot lately about an apparen...

A detailed tutorial on master-slave replication and read-write separation of MySQL database

Table of contents Preface 1. MySQL master-slave r...

A brief analysis of event bubbling and event capture in js

Table of contents 01-Event Bubbling 1.1- Introduc...

Vue3.0 implements the encapsulation of the drop-down menu

Vue3.0 has been out for a while, and it is necess...

Implementation of positioning CSS child elements relative to parent elements

Solution Add position:relative to the parent elem...

Detailed explanation of gantt chart draggable and editable (highcharts can be used for vue and react)

Preface Excel is powerful and widely used. With t...

HTML uses regular expressions to test table examples

Here is an example code for using regular express...