innobackupex: Error: Failed to connect to MySQL server as DBD::mysql module is not installed
来源:互联网 发布:tensorflow车道线识别 编辑:程序博客网 时间:2024/06/06 17:53
innobackupex同时支持备份innodb和MyISAM(会加一个全局的读锁)。
[mysql@gdsDB bin]$ ./innobackupex --user=root --password= --socket=/oradata/MC/mysqldata/3308/mysql.sock --defaults-file=/oradata/MC/mysqldata/3308/my.cnf /oradata/MC/mysqldata/backup --no-timestamp
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oyand 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
170323 09:00:05 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/oradata/MC/mysqldata/3308/my.cnf;mysql_read_default_group=xtrabackup;mysql_socket=/oradata/MC/mysqldata/3308/mysql.sock' as 'root' (using password: NO).
innobackupex: Error: Failed to connect to MySQL server as DBD::mysql module is not installed at ./innobackupex line 2976.
[mysql@gdsDB bin]$ ./innobackupex --user=root --password= --socket=/oradata/MC/mysqldata/3308/mysql.sock --defaults-file=/oradata/MC/mysqldata/3308/my.cnf /oradata/MC/mysqldata/backup --no-timestamp
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
170323 09:00:45 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/oradata/MC/mysqldata/3308/my.cnf;mysql_read_default_group=xtrabackup;mysql_socket=/oradata/MC/mysqldata/3308/mysql.sock' as 'root' (using password: NO).
innobackupex: Error: Failed to connect to MySQL server as DBD::mysql module is not installed at ./innobackupex line 2976.
根据操作系统的版本安装合适的perl-DBD-MySQL,因为innobackupex是一个封装了xtrabackup的perl脚本。
[root@gdsDB MC]# rpm -ivh perl-DBD-MySQL-4.013-3.el6.x86_64.rpm
warning: perl-DBD-MySQL-4.013-3.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID c105b9de: NOKEY
Preparing... ########################################### [100%]
1:perl-DBD-MySQL ########################################### [100%]
[mysql@gdsDB bin]$ ./innobackupex --user=root --password= --socket=/oradata/MC/mysqldata/3308/mysql.sock --defaults-file=/oradata/MC/mysqldata/3308/my.cnf /oradata/MC/mysqldata/backup --no-timestamp
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
170323 09:07:26 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/oradata/MC/mysqldata/3308/my.cnf;mysql_read_default_group=xtrabackup;mysql_socket=/oradata/MC/mysqldata/3308/mysql.sock' as 'root' (using password: NO).
170323 09:07:26 innobackupex: Connected to MySQL server
170323 09:07:26 innobackupex: Executing a version check against the server...
170323 09:07:26 innobackupex: Done.
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.6.25-log
sh: xtrabackup_56: command not found
innobackupex: Error: no 'mysqld' group in MySQL options at ./innobackupex line 4377.
把环境变量加上去即可
[mysql@gdsDB bin]$ export PATH=/oradata/MC/mysqldata/percona-xtrabackup-2.1.7-Linux-x86_64/bin:$PATH
再次执行命令成功
0 0
- innobackupex: Error: Failed to connect to MySQL server as DBD::mysql module is not installed
- innobackupex: Error: Failed to connect to MySQL server as DBD::mysql module is not installed at /usr
- innobackupex: Error: Failed to connect to MySQL server as DBD
- Error: Failed to connect to MySQL server: DBI connect(';
- ERROR: Failed to connect to MySQL server: DBI connect(';mysql_read_default_file
- [MySQL]MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
- MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
- MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
- mysql:ERROR 1130: Host '192.168.0.102' is not allowed to connect to this MySQL server
- MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
- MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
- mysql数据库错误ERROR 1130:Host '' is not allowed to connect to this mysql server
- MySql - SQL Error (1130): Host IP is not allowed to connect to this MySQL server
- 解决MySQL ERROR 1130 (HY000): Host 'XXX' is not allowed to connect to this MySQL server
- MySql - SQL Error (1130): Host IP is not allowed to connect to this MySQL server
- mysql ERROR 1130: Host ’localhost′ is not allowed to connect to this MySQL server
- 解决MySQL ERROR 1130 (HY000): Host 'XXXX' is not allowed to connect to this MySQL server
- 【mysql】ERROR 1130: Host ’...′ is not allowed to connect to this MySQL server
- 设计模式学习笔记-观察者模式
- Stencil Shadow Volume技术讲解
- Linux-Ubuntu16.04下Python3.5安装pip3以及scrapy、numpy、itchat
- 30+的人学Java,数组是啥玩意?
- 三维扫描仪[3]——标定·理论
- innobackupex: Error: Failed to connect to MySQL server as DBD::mysql module is not installed
- 团体程序设计天梯赛-练习集 L2-010. 排座位
- 为什么选择Chrome浏览器
- 每个程序员都应该了解的内存知识1——内存概述
- Sicily LIS |动态规划
- SpringBoot+SpringDataJpa后台常用注解
- myBatis连接MySQL初级应用_01
- windows下的mongodb的安装+将mongodb 做成windows service方式
- XON/XOFF