• 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/


    备份成功


  • 相关阅读:
    13 数据库主从
    12 数据备份
    11 锁机制
    12 日志
    10 索引(二)
    09 索引
    update kernel 3.10-3.12
    haproxy para config
    mysql slave to master
    storage disk
  • 原文地址:https://www.cnblogs.com/twodog/p/12141108.html
Copyright © 2020-2023  润新知