• 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合集之Python字典(一)
    Python合集之Python元组(三)
    Python合集之Python元组(二)
    Python合集之Python元组(一)
    Python合集之Python列表(七)
    Python合集之Python列表(六)
    Python合集之Python列表(五)
    Python合集之Python列表(四)
    Python合集之Python列表(三)
    对《软件工程》课程的总结
  • 原文地址:https://www.cnblogs.com/twodog/p/12141109.html
Copyright © 2020-2023  润新知