1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
|
########################################################################
# Bug #711166: Partitioned tables are not correctly handled by the
# --databases and --tables-file options of innobackupex,
# and by the --tables option of xtrabackup.
# Testcase covers using --tables-file option with InnoDB
# database and --stream mode
########################################################################
. inc/common.sh
. inc/ib_part.sh
start_server --innodb_file_per_table
require_partitioning
# Create InnoDB partitioned table
ib_part_init $topdir InnoDB
# Saving the checksum of original table
checksum_a=`checksum_table test test`
# Take a backup
# Only backup of test.test table will be taken
cat >$topdir/tables <<EOF
test.test
EOF
mkdir -p $topdir/backup
innobackupex --stream=tar --no-timestamp --tables-file=$topdir/tables $topdir/backup > $topdir/backup/backup.tar
$TAR ixvf $topdir/backup/backup.tar -C $topdir/backup
innobackupex --apply-log $topdir/backup
vlog "Backup taken"
stop_server
# Restore partial backup
ib_part_restore $topdir $mysql_datadir
start_server
ib_part_assert_checksum $checksum_a
|