blob: b03b9705569f52d8c1fe1a58cb4edbd3dd52ac16 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
# Create 2 UNDO TABLESPACE(UNDO001(space_id =3), UNDO002(space_id =4))
CREATE TABLE t1(a varchar(60)) ENGINE INNODB;
start transaction;
INSERT INTO t1 VALUES(1);
# xtrabackup backup
# Display undo log files from target directory
undo001
undo002
# xtrabackup prepare
# Display undo log files from targer directory
undo001
undo002
DROP TABLE t1;
|