CREATE TABLE t1(i int) ENGINE INNODB; set global innodb_log_checkpoint_now = 1; # xtrabackup prepare # shutdown server # remove datadir # xtrabackup move back # restart CREATE TABLE t1(i int); DROP TABLE t1; SELECT * from t2; i DROP TABLE t2;