XBK备份错误日志记录

[root@joker backup]# innobackupex --user=root --password=  --no-timestamp ----defaults-file=/etc/my.cnf  /backup/full
xtrabackup: recognized server arguments: --datadir=/data/mysql/data --server-id=6 --log_bin=/data/binlog/mysql-bin 
xtrabackup: recognized client arguments: --datadir=/data/mysql/data --server-id=6 --log_bin=/data/binlog/mysql-bin 
200915 15:39:18 innobackupex: Starting the backup operation

IMPORTANT: Please check that the backup run completes successfully.
           At the end of a successful backup run innobackupex
           prints "completed OK!".

200915 15:39:18  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root'  (using password: NO).
Failed to connect to MySQL server: DBI connect(';mysql_read_default_group=xtrabackup','root',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at - line 1314.
200915 15:39:18 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).

 

=根据错误提示，发现XBK通过socket文件链接mysql 所以直接给它指定socket文件位置如下

innobackupex --user=root --password=  --no-timestamp ----defaults-file=/etc/my.cnf --socket=/tmp/mysql.sock   /backup/full

增量备份命令

innobackupex   --user=root --no-timestamp --socket=/tmp/mysql.sock --incremental --incremental-basedir=/backup/full /backup/inc2

可以顺利进行备份，备忘