--source include/have_innodb.inc --let $targetdir=$MYSQLTEST_VARDIR/tmp/backup CREATE TABLE t1 (pk INT PRIMARY KEY, a YEAR UNSIGNED) ENGINE=InnoDB ROW_FORMAT=REDUNDANT; INSERT INTO t1 VALUES (1,2021),(2,21),(3,0); UPDATE t1 SET a = NULL; exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --target-dir=$targetdir; exec $XTRABACKUP --prepare --verbose --target-dir=$targetdir; --source include/restart_and_restore.inc rmdir $targetdir; SELECT * FROM t1; DROP TABLE t1;