MySQL xtrabackup之--databases 勿手贱

时间:2023-03-08 16:59:34

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

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

谨慎,进行相关操作。