在CentOS 7.2上使用innobackupex v2.4.6备份MySQL 5.7.16时遇到错误：Unrecognized character x01。经过排查，该问题并非由于已知bug引起。最终发现是由于未指定MySQL的socket文件位置导致，通过添加--socket参数指定/app/mysql/data/mysql.sock成功解决了连接问题。
centos 7.2
mysql 5.7.16
innobackupex version 2.4.6
[root@Devops-mysql-150-115 sh]# innobackupex --defaults-file=/app/mysql/servers/etc/ --user=root --password=xxxxxx /backup/mysql/
备份出现错误：（有2个提示）
1. Unrecognized character \x01; marked by <-- HERE after <-- HERE near column 1 at - line 1374.
google搜索后说bug。
170309 00:42:54 innobackupex: Starting the backup operation
Failed to connect to MySQL server: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
看这个不像。
####错误具体信息：
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
prints "completed OK!".
Unrecognized character \x01; marked by <-- HERE after <-- HERE near column 1 at - line 1374.
170309 00:42:54 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set
Failed to connect to MySQL server: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2).
###### 解决方法：
指定sock文件位置就ok了
innobackupex --defaults-file=/app/mysql/servers/etc/ --socket=/app/mysql/data/mysql.sock --user=root --password=xxxx /backup/mysql/
备份成功
扫一扫
5万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
