XtraBackup 可以恢复数据库,但备份报错。

2015-08-13 08:07:27 +08:00
 woi911

都是采用rpm 安装的。
yum -y install perl perl-devel libaio libaio-devel perl-Time-HiRes perl-DBD-MySQL

centos 6.8 x32 可以正常还原和备份
rpm -ivh percona-xtrabackup-2.2.12-1.el6.i686.rpm

innobackupex --database="x" --user=root --password=woi911 --stream=tar ./ | gzip - > /backup/sql-backuped-date +%F__%H-%M.tar.gz

centos 6.8 x64 可以正常还原,但备份报错。
rpm -ivh percona-xtrabackup-2.2.12-1.el6.x86_64.rpm

[code]
innobackupex --database="x" --user=root --password=woi911 --stream=tar ./ | gzip - > /backup/sql-backuped-date +%F__%H-%M.tar.gz

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p

150813 08:02:15 innobackupex: Executing a version check against the server...
150813 08:02:15 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root' (using password: YES).
innobackupex: got a fatal error with the following stacktrace: at /usr/bin/innobackupex line 3006
main::mysql_connect('abort_on_error', 1) called at /usr/bin/innobackupex line 1551
innobackupex: Error: Failed to connect to MySQL server as DBD::mysql module is not installed at /usr/bin/innobackupex line 3006.
150813 08:02:15 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root' (using password: YES).
innobackupex: got a fatal error with the following stacktrace: at /usr/bin/innobackupex line 3006
main::mysql_connect('abort_on_error', 1) called at /usr/bin/innobackupex line 1570
innobackupex: Error: Failed to connect to MySQL server as DBD::mysql module is not installed at /usr/bin/innobackupex line 3006.
[/code]

找了很多资料,percona 官网也看了,还是没找到解决方法。

2430 次点击
所在节点    MySQL
1 条回复
julyclyde
2015-08-14 14:34:21 +08:00
DBD::mysql module is not installed

这是一个专为移动设备优化的页面(即为了让你能够在 Google 搜索结果里秒开这个页面),如果你希望参与 V2EX 社区的讨论,你可以继续到 V2EX 上打开本讨论主题的完整版本。

https://www.v2ex.com/t/212836

V2EX 是创意工作者们的社区,是一个分享自己正在做的有趣事物、交流想法,可以遇见新朋友甚至新机会的地方。

V2EX is a community of developers, designers and creative people.

© 2021 V2EX