MySQL xtrabackup之--databases 勿手贱

 

xtrabackup备份单库时，必须指定--databases，但是如果将databases写成了database，那么xtrabackup备份的就是整个数据库，以下是

 

 

uuid = 397ae42e-4092-11e7-9332-0050569a6b82
name =
tool_name = innobackupex
tool_command = --defaults-file=/etc/my.cnf --user=root --password=... --database=scz /dbbackup/
tool_version = 2.4.4
ibbackup_version = 2.4.4
server_version = 5.6.35-log
start_time = 2017-05-24 22:23:48
end_time = 2017-05-24 23:04:03
lock_time = 0
binlog_pos = filename 'MySQL-bin.000015', position '1044007307'
innodb_from_lsn = 0
innodb_to_lsn = 145633724792
partial = N
incremental = N
format = file
compact = N
compressed = N
encrypted = N

　　得到的备份集包括所有的数据库。

 

谨慎，进行相关操作。