mysql enterprise backup 备份可能出错的地方

郑全

[root@sztech1 ~]# mysqlbackup -uroot -proot --socket=/usr/local/mysql/mysql.sock  --backup_dir=/u01/back_data backup-and-apply-log
MySQL Enterprise Backup version 3.11.0 Linux-3.8.13-16.2.1.el6uek.x86_64-x86_64 [2014/08/26]
Copyright (c) 2003, 2014, Oracle and/or its affiliates. All Rights Reserved.

 mysqlbackup: INFO: Starting with following command line ...
 mysqlbackup -uroot -pxxxx --socket=/usr/local/mysql/mysql.sock
        --backup_dir=/u01/back_data backup-and-apply-log

 mysqlbackup: INFO:
 mysqlbackup: INFO: MySQL server version is '5.6.23-log'.
 mysqlbackup: INFO: Got some server configuration information from running server.

 mysqlbackup: ERROR: Backup directory already exists and is not empty.
  Please remove backup directory and retry.

mysqlbackup failed with errors!

 

 

--backup_dir 必须是空目录。

郑全

对于源码安装，使用这个mysqlbackup ,默认socket在/tmp/mysql.sock ，因此需要指定 --socket，否则，要报错：

[root@sztech1 ~]# mysqlbackup -uroot -proot   --backup_dir=/u01/dbback/ backup-and-apply-log
MySQL Enterprise Backup version 3.11.0 Linux-3.8.13-16.2.1.el6uek.x86_64-x86_64 [2014/08/26]
Copyright (c) 2003, 2014, Oracle and/or its affiliates. All Rights Reserved.

 mysqlbackup: INFO: Starting with following command line ...
 mysqlbackup -uroot -pxxxx --backup_dir=/u01/dbback/ backup-and-apply-log

 mysqlbackup: INFO:
150424 08:25:22 mysqlbackup: WARNING: Can not establish connection to mysql server.
      Connection open fails with error "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"
 mysqlbackup: ERROR: Connection initialization error.

mysqlbackup failed with errors!