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

共计 827 个字符，预计需要花费 3 分钟才能阅读完成。

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

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 下

本文永久更新链接地址 ：http://www.linuxidc.com/Linux/2016-08/134769.htm