xtrabackup启动报错处理

报错1:

xtrabackup_56: error while loading shared libraries: libssl.so.6: cannot open shared object file: No such file or directory 
innobackupex: fatal error: no 'mysqld' group in MySQL options 
DBD::mysql::db selectrow_array failed: MySQL server has gone away at /usr/local/mysql/bin/innobackupex line 1325. 
安装: yum -y install openssl

报错2:

[root@db1 data]# innobackupex --user=root -proot --database=test --defaults-file=/etc/my.cnf /home/

Can't locate Time/HiRes.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at /usr/bin/innobackupex line 23.

BEGIN failed--compilation aborted at /usr/bin/innobackupex line

解决方法:

yum install perl-Time-HiRes


报错:3:

[root@dbtest bin]# innobackupex --user=root --password=root --defaults-file=/etc/my.cnf --socket=/tmp/mysql.sock  /home/backup_xtra


InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy

and Percona Ireland Ltd 2009-2012.  All Rights Reserved.


This software is published under

the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.


130608 10:22:29  innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/etc/my.cnf;mysql_read_default_group=xtrabackup;mysql_socket=/tmp/mysql.sock' as 'root'  (using password: YES).

ERROR: Failed to connect to MySQL server as DBD::mysql module is not installed at /usr/bin/innobackupex line 1397.


解决方法:

yum -y install perl-DBD-MySQL.x86_64



报错4:

root@dbtest bin]# ./innobackupex --defaults-file=/etc/my.cnf --user=root --password=root  --socket=/tmp/mysql.sock  /home/backup


InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy

and Percona Ireland Ltd 2009-2012.  All Rights Reserved.


This software is published under

the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.


130608 10:41:30  innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/etc/my.cnf;mysql_read_default_group=xtrabackup;mysql_socket=/tmp/mysql.sock' as 'root'  (using password: YES).

130608 10:41:30  innobackupex: Connected to MySQL server

IMPORTANT: Please check that the backup run completes successfully.

          At the end of a successful backup run innobackupex

          prints "completed OK!".


innobackupex: Using mysql server version 5.5.22-log


xtrabackup_55: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

innobackupex: fatal error: no 'mysqld' group in MySQL options


解决方法:

yum -y install libaio*



原文地址:http://my.oschina.net/sansom/blog/160468



  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值