DBA---------------------------数据库--------------------XBK(xtrabackup) 备份

1.登入MYSQL创建数据库

create database full charset utf8mb4;
use full;
create table t1(id int);
 insert into t1 values(1),(2),(3);
commit;

2.备份数据库

innobackupex --user=root --password=123 --no-timestamp --socket=/tmp/mysql.sock /backup/full

3.

create database inc1 charset utf8mb4;
use inc1;
create table t1(id int);
 insert into t1 values(1),(2),(3);
commit;

4.在

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