xtrabackup连接不上MySQL的问题

使用xtrabackup备份问题

[root@localhost ~]# innobackupex --user=root --password=131417 /backup

以下是错误提示：
innobackupex: got a fatal error with the following stacktrace: at /usr/bin/innobackupex line 3011.
main::mysql_connect('abort_on_error', 1) called at /usr/bin/innobackupex line 1551
innobackupex: Error: Failed to connect to MySQL server: DBI connect(';mysql_read_default_group=xtrabackup','root',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/bin/innobackupex line 2995.
150712 22:29:59 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 3011.
main::mysql_connect('abort_on_error', 1) called at /usr/bin/innobackupex line 1570
innobackupex: Error: Failed to connect to MySQL server: DBI connect(';mysql_read_default_group=xtrabackup','root',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/bin/innobackupex line 2995.

解决方法：

innobackupex是通过socket的方式链接上去的。想办法使它不走socket就可以了。

innobackupex --user=root --password=131417 --host=127.0.0.1 /backup

我的备份全库并压缩命令

innobackupex --defaults-file=/etc/my.cnf --user=root --password=数据库密码 --host=127.0.0.1  \   --stream=xbstream  /data/A/mysql/Allbackup | gzip > /data/A/mysql/Allbackup.tar.gz

• 本文作者： GaryWu
• 本文链接： https://garywu520.github.io/2018/02/08/xtrabackup连接不上MySQL的问题/
• 版权声明： 本博客所有文章除特别声明外，均采用 MIT 许可协议。转载请注明出处！