Xtrabackup备份报错Failed to connect to MySQL server Bertha 。 2024-04-18 00:35 18阅读 0赞 Xtrabackup备份报错 /backup> innobackupex --defaults-file=/etc/my.cnf --user=root --password='xxxxx' /backup/20170803 170421 18:15:39 innobackupex: Starting the backup operation IMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex prints "completed OK!". 170421 18:15:39 version\_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql\_read\_default\_group=xtrabackup' as 'root' (using password: YES). 170421 18:15:39 version\_check Connected to MySQL server 170421 18:15:39 version\_check Executing a version check against the server... 170421 18:15:39 version\_check Done. 170421 18:15:39 Connecting to MySQL server host: localhost, user: root, password: set, port: 0, socket: (null) Failed to connect to MySQL server: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). 仔细检查,发现输入的用户名和密码都是正确的,而且可以正常连接到数据库 /backup/MySQL\_Backup/bin> mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \\g. Your MySQL connection id is 12 Server version: 5.6.21-70.1-log Percona Server (GPL), Release 70.1, Revision 698 Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement. mysql> 报错原因: 在配置文件中没有配置socket Xtrabackup在备份时,会使用本地的socket 连接到数据库 解决方法: 在配置文件中增加socket选项 \[root@localhost bin\]\# cat /etc/my.cnf \[mysqld\] basedir = /usr datadir = /var/lib/mysql log-error = /var/lib/mysql/localhost.localdomain.err pid-file = /var/lib/mysql/localhost.localdomain.pid \#port = 3306 socket = /var/lib/mysql/mysql.sock 之后重启数据库,可以正常备份 /backup> innobackupex --defaults-file=/etc/my.cnf --user=backup --password='backup' /backup/20170803 170421 18:34:54 innobackupex: Starting the backup operation IMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex prints "completed OK!". 170421 18:34:54 version\_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql\_read\_default\_group=xtrabackup;mysql\_socket=/var/lib/mysql/mysql.sock' as 'backup' (using password: YES). 170421 18:34:54 version\_check Connected to MySQL server 170421 18:34:54 version\_check Executing a version check against the server... 170421 18:34:54 version\_check Done. 170421 18:34:54 Connecting to MySQL server host: localhost, user: backup, password: set, port: 0, socket: /var/lib/mysql/mysql.sock Using server version 5.6.21-70.1-log innobackupex version 2.4.4 based on MySQL server 5.7.13 Linux (x86\_64) (revision id: df58cf2) xtrabackup: uses posix\_fadvise(). xtrabackup: cd to /var/lib/mysql xtrabackup: open files limit requested 0, set to 32768 xtrabackup: using the following InnoDB configuration: xtrabackup: innodb\_data\_home\_dir = . xtrabackup: innodb\_data\_file\_path = ibdata1:12M:autoextend xtrabackup: innodb\_log\_group\_home\_dir = ./ xtrabackup: innodb\_log\_files\_in\_group = 2 xtrabackup: innodb\_log\_file\_size = 50331648 InnoDB: Number of pools: 1 170421 18:34:54 >> log scanned up to (201239294) xtrabackup: Generating a list of tablespaces InnoDB: Allocated tablespace ID 45 for dmcdbTEST/com\_numbering\_plan, old maximum was 0 170421 18:34:55 >> log scanned up to (201239294) 170421 18:34:55 \[01\] Copying ./ibdata1 to /backup/20170803/2017-04-21\_18-34-54/ibdata1 170421 18:34:56 >> log scanned up to (201239294) 170421 18:34:57 >> log scanned up to (201239294) 来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26506993/viewspace-2143020/,如需转载,请注明出处,否则将追究法律责任。 转载于:http://blog.itpub.net/26506993/viewspace-2143020/
还没有评论,来说两句吧...