blob: 4e45127bd6a7cdf8b46145907327d4c0390d28c8 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
CREATE TABLE t(a INT) ENGINE=InnoDB DATA DIRECTORY='table_data_dir';
INSERT INTO t VALUES(1);
# xtrabackup backup
# xtrabackup prepare
DROP TABLE t;
# shutdown server
# remove datadir
# xtrabackup move back
# restart
SELECT * FROM t;
a
1
DROP TABLE t;
|