使用innobackupex备份遇到的问题和解决方法

来源：互联网发布：sql update 效率编辑：程序博客网时间：2024/06/08 03:41

1. "Can't locate Time/HiRes.pm in @INC"

解决方法：yum -y install perl-Time-HiRes

2.innobackupex: Error: Failed to connect to MySQL server as DBD::mysql module is not installed at ./innobackupex line 2999.

解决办法：yum install -y perl-DBD-MySQL

3. sh: xtrabackup: command not found
innobackupex: got a fatal error with the following stacktrace: at ./innobackupex line 2704
main::wait_for_ibbackup_file_create('/data/backup/2015-09-28_17-59-26/xtrabackup_suspended_2') called at ./innobackupex line 2724
main::wait_for_ibbackup_suspend('/data/backup/2015-09-28_17-59-26/xtrabackup_suspended_2') called at ./innobackupex line 1977
main::backup() called at ./innobackupex line 1601
innobackupex: Error: The xtrabackup child process has died at ./innobackupex line 2704.

解决方法：将innobackupex xbcrypt xbstream xtrabackup这几个执行文件拷贝到/usr/bin下

0 0