innobackupex 出现Unrecognized character \x01; marked by <-- HERE after <-- HERE near column 1 at - line 1374.

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/


备份成功


上一篇:如何看mysql锁信息


下一篇:Py碎碎学_之基本元素:数字、 字符串和变量