1--source include/have_partition.inc 2--source include/have_symlink.inc 3let $targetdir=$MYSQLTEST_VARDIR/backup; 4mkdir $targetdir; 5mkdir $MYSQLTEST_VARDIR/partitdata; 6 7--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR 8eval CREATE TABLE t(i int) 9ENGINE=InnoDB 10PARTITION BY RANGE (i) 11(PARTITION p0 VALUES LESS THAN (100), 12 PARTITION P1 VALUES LESS THAN (200), 13 PARTITION p2 VALUES LESS THAN (300) DATA DIRECTORY = '$MYSQLTEST_VARDIR/partitdata', 14 PARTITION p3 VALUES LESS THAN (400) DATA DIRECTORY = '$MYSQLTEST_VARDIR/partitdata', 15 PARTITION p4 VALUES LESS THAN MAXVALUE); 16INSERT INTO t VALUES (1), (101), (201), (301), (401); 17exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --target-dir=$targetdir; 18exec $XTRABACKUP --prepare --target-dir=$targetdir; 19DROP TABLE t; 20rmdir $MYSQLTEST_VARDIR/partitdata; 21--source include/restart_and_restore.inc 22--enable_result_log 23SELECT * FROM t; 24DROP TABLE t; 25rmdir $targetdir; 26rmdir $MYSQLTEST_VARDIR/partitdata; 27