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