Debian Codegraph @

mysql-test/suite/mariabackup/partition_partial.test

raw
1 #--source include/innodb_page_size.inc
2 --source include/have_partition.inc
3
4 # import partitioned table from table from partial backup
5
6 CREATE TABLE t1(i INT) ENGINE INNODB
7 PARTITION BY RANGE (i)
8 (PARTITION p1 VALUES LESS THAN (100),
9 PARTITION p2 VALUES LESS THAN (200),
10 PARTITION p3 VALUES LESS THAN (300),
11 PARTITION p4 VALUES LESS THAN (400));
12
13 INSERT INTO t1 VALUES (1), (101), (201), (301);
14
15 echo # xtrabackup backup;
16
17 let $targetdir=$MYSQLTEST_VARDIR/tmp/backup;
18 --disable_result_log
19 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --parallel=10 "--tables=test.t1" --target-dir=$targetdir;
20 --enable_result_log
21 INSERT INTO t1 VALUES (1), (101), (201), (301);
22
23
24 echo # xtrabackup prepare;
25 --disable_result_log
26 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --defaults-group-suffix=.1 --prepare --export --target-dir=$targetdir;
27 --enable_result_log
28
29
30 let $MYSQLD_DATADIR= `select @@datadir`;
31 CREATE TABLE t1_placeholder (i INT) ENGINE INNODB;
32 let $i=4;
33 while($i)
34 {
35 eval ALTER TABLE t1_placeholder DISCARD TABLESPACE;
36 copy_file $targetdir/test/t1#P#p$i.cfg $MYSQLD_DATADIR/test/t1_placeholder.cfg;
37 copy_file $targetdir/test/t1#P#p$i.ibd $MYSQLD_DATADIR/test/t1_placeholder.ibd;
38 eval ALTER TABLE t1_placeholder IMPORT TABLESPACE;
39 eval ALTER TABLE t1 EXCHANGE PARTITION p$i WITH TABLE t1_placeholder;
40 dec $i;
41 }
42 SELECT * FROM t1;
43 DROP TABLE t1;
44 DROP TABLE t1_placeholder;
45 rmdir $targetdir;