--source include/have_innodb.inc

CREATE TABLE t (pk INT PRIMARY KEY) ENGINE=InnoDB ROW_FORMAT=COMPRESSED;

INSERT INTO t VALUES (1),(2);

--source include/restart_mysqld.inc

DELETE FROM t;

--echo # Running backup

--exec $XTRABACKUP --backup --target-dir=$MYSQL_TMP_DIR/mbackup_backup --protocol=tcp --port=$MASTER_MYPORT --user=root

--echo # Running prepare

--exec $XTRABACKUP --prepare --target-dir=$MYSQL_TMP_DIR/mbackup_backup

--echo # Running restore

--exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --copy-back --datadir=$MYSQL_TMP_DIR/mbackup_restore --target-dir=$MYSQL_TMP_DIR/mbackup_backup

--echo # Restarting on the restored datadir

--let $restart_parameters= --datadir=$MYSQL_TMP_DIR/mbackup_restore

--source include/restart_mysqld.inc

SELECT * FROM t;

CREATE TABLE t (pk INT PRIMARY KEY) ENGINE=InnoDB ROW_FORMAT=COMPRESSED;

INSERT INTO t VALUES (1),(2);

DELETE FROM t;

# Running backup

# Running prepare

# Running restore

# Restarting on the restored datadir

SELECT * FROM t;

pk

1

2