An example of a xtrabackup backup execution error

Source: Internet
Author: User
Tags install perl percona


I. Description of the problem
In full backup with Xtrabackup online mysql times wrong:
[mysql@mvxl0782 ~]$ Innobackupex--defaults-file=/data/mysql/mysql3376/my3376.cnf--user=xtrabk--password= ' Onlybackup '/data/backup/

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.

This software is published under
The GNU general public LICENSE Version 2, June 1991.

Get the latest version of Percona Xtrabackup, documentation, and help:
http://www.percona.com/xb/p

160517 15:57:43 innobackupex:connecting to MySQL server with DSN

' Dbi:mysql:;mysql_read_default_file=/data/mysql/mysql3376/data/my3376.cnf;mysql_read_default_group=xtrabackup ' As ' XTRABK ' (using Password:yes).
Innobackupex:got a fatal error with the following stacktrace:at/usr/local/percona-xtrabackup-2.2.9-linux-x86_64/bin/ Innobackupex Line 2999
Main::mysql_connect (' Abort_on_error ', 1) called at/usr/local/percona-xtrabackup-2.2.9-linux-x86_64/bin/ Innobackupex Line 1539
innobackupex:Error:Failed to connect to MySQL server as Dbd::mysql module is not installed At/usr/local/percona-xtrabac Kup-2.2.9-linux-x86_64/bin/innobackupex Line

2999.

Second, the problem analysis
It is apparent from above that the DBD is not installed.

third, solve the problem:
[root@mvxl0782 local]# Yum Install Perl-dbd-mysql
Loaded Plugins:product-id, Refresh-packagekit, security, Subscription-manager
Updating certificate-based repositories.
Unable to read consumer identity
Rhel6 | 4.0 KB 00:00
Setting up Install Process
Resolving dependencies
--> Running Transaction Check
---> Package perl-dbd-mysql.x86_64 0:4.013-3.el6 would be installed
--> processing dependency:libmysqlclient.so.16 (libmysqlclient_16) (64bit) for package: Perl-dbd-mysql-4.013-3.el6.x86_64
--> processing dependency:libmysqlclient.so.16 () (64bit) for package:perl-dbd-mysql-4.013-3.el6.x86_64
--> Running Transaction Check
---> Package mysql-libs.x86_64 0:5.1.61-4.el6 would be installed
--> finished Dependency resolution

Dependencies resolved

=============================================================================================================== =====================
Package Arch Version Repository Size
=============================================================================================================== =====================
Installing:
Perl-dbd-mysql x86_64 4.013-3.el6 rhel6 134 K
Installing for dependencies:
Mysql-libs x86_64 5.1.61-4.el6 rhel6 1.2 M

Transaction Summary
=============================================================================================================== =====================
Install 2 Package (s)

Total Download size:1.4 M
Installed size:4.4 M
Is this OK [y/n]: Y
Downloading Packages:
(1/2): mysql-libs-5.1.61-4.el6.x86_64.rpm | 1.2 MB 00:00
(2/2): perl-dbd-mysql-4.013-3.el6.x86_64.rpm | 134 KB 00:00
--------------------------------------------------------------------------------------------------------------- ---------------------
Total MB/s | 1.4 MB 00:00
Running Rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing:mysql-libs-5.1.61-4.el6.x86_64 1/2
Warning:/etc/my.cnf created as/etc/my.cnf.rpmnew
Installing:perl-dbd-mysql-4.013-3.el6.x86_64 2/2
Installed products updated.
Verifying:perl-dbd-mysql-4.013-3.el6.x86_64 1/2
  verifying : mysql-libs-5.1.61-4.el6.x86_64                                                                                        2/2

Installed:
  perl-dbd-mysql.x86_64 0:4.013-3.el6                                                                                                   

Dependency installed:
Mysql-libs.x86_64 0:5.1.61-4.el6

complete!

To perform a backup successfully
[mysql@mvxl0782 ~]$ Innobackupex--defaults-file=/data/mysql/mysql3376/my3376.cnf--user=xtrabk--password= ' Onlybackup '--slave-info/data/backup/

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.