CREATE TABLE t(i INT) ENGINE INNODB; INSERT INTO t VALUES(1); # xtrabackup backup # xtrabackup prepare # shutdown server # remove datadir # xtrabackup move back # restart # shutdown server # remove datadir # xtrabackup move back # restart # shutdown server # remove datadir # xtrabackup move back # restart SELECT * FROM t; i 1 DROP TABLE t;