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