报错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