innobackupex 出现Unrecognized character \x01; marked by
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/
备份成功
最新文章
- python小知识积累
- 一张图理解prototype、proto和constructor的三角关系
- grid列的值格式化
- 地理围栏算法解析(Geo-fencing)
- POJ 1338
- Matlab之类型转换
- 【转】ubuntu下自动挂载硬盘分区
- 《深入理解linux内核》第一章 序论
- 与数据库打交道的Adapter----SimpleCursorAdapter
- poj 2135 Farm Tour 费用流
- VB6.0快捷键大全(转)
- [05-01]Linux如何重启系统
- TypeSrcript如何引入第三方库 如果加d.ts以及async await如何使用 demo,只有代码,文字后续补充
- 2019.3.28&;2019.3.30考试
- C# XML 文档注释
- AngularJs表单自动验证
- ev3dev:c语言开发lego ev3主机
- HTML5的video虽然可用controls来展示控件
- CentOS 6.5 下搭建NTP服务器
- MVC5应用程序生命周期lifecycle