当前位置: 首页 > 工具软件 > XtraBackup > 使用案例 >

xtrabackup 报错

龚威
2023-12-01

innobackupex: Error: Failed to connect to MySQL server as DBD::mysql module is not installed at /usr/local/mysql55/bin/innobackupex line 2956.

错误原因:未安装 perl-DBD-MySQL

解决方法:yum install -y perl-DBD-MySQL


innobackupex: Error: Failed to connect to MySQL server: DBI connect(';mysql_read_default_file=/data//mysqldata/3306/my.cnf;mysql_read_default_group=xtrabackup','root',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at /usr/local/mysql55/bin/innobackupex line 2945

错误原因:很明显是用户名或密码登录不上mysql



sh: xtrabackup_55: command not found
innobackupex: Error: no 'mysqld' group in MySQL options at /usr/local/mysql55/bin/innobackupex line 4357.

错误原因:innobackupex在备份innodb的表时会调用xtrabackup,具体用到的名称就是xtrabackup_55,所以在将xtrabackup做软连接的时候最好做成xtrabackup_55

解决方法:

ln -s /usr/local/percona-xtrabackup-2.1.8/src/xtrabackup_innodb55    /usr/local/mysql55/bin/xtraback_55



 类似资料: