5
load_dbase_schema incremental_sample
9
vlog "Adding initial rows to database..."
13
while [ "$numrow" -gt "$count" ]
15
${MYSQL} ${MYSQL_ARGS} -e "insert into test values ($count, $numrow);" incremental_sample
20
vlog "Initial rows added"
25
mkdir -p $topdir/data/full
27
mkdir -p $topdir/data/delta
29
vlog "Starting backup"
31
xtrabackup --datadir=$mysql_datadir --backup --target-dir=$topdir/data/full
33
vlog "Full backup done"
35
# Changing data in sakila
37
vlog "Making changes to database"
41
while [ "$numrow" -gt "$count" ]
43
${MYSQL} ${MYSQL_ARGS} -e "insert into test values ($count, $numrow);" incremental_sample
49
# Saving the checksum of original table
50
checksum_a=`${MYSQL} ${MYSQL_ARGS} -Ns -e "checksum table test;" incremental_sample | awk '{print $2}'`
52
vlog "Table checksum is $checksum_a"
54
vlog "Making incremental backup"
57
xtrabackup --datadir=$mysql_datadir --backup --target-dir=$topdir/data/delta --incremental-basedir=$topdir/data/full
59
vlog "Incremental backup done"
60
vlog "Preparing backup"
63
xtrabackup --datadir=$mysql_datadir --prepare --apply-log-only --target-dir=$topdir/data/full
64
vlog "Log applied to backup"
65
xtrabackup --datadir=$mysql_datadir --prepare --apply-log-only --target-dir=$topdir/data/full --incremental-dir=$topdir/data/delta
66
vlog "Delta applied to backup"
67
xtrabackup --datadir=$mysql_datadir --prepare --target-dir=$topdir/data/full
68
vlog "Data prepared for restore"
72
${MYSQL} ${MYSQL_ARGS} -e "delete from test;" incremental_sample
81
cp -r * $mysql_datadir
88
vlog "Cheking checksums"
89
checksum_b=`${MYSQL} ${MYSQL_ARGS} -Ns -e "checksum table test;" incremental_sample | awk '{print $2}'`
91
if [ $checksum_a -ne $checksum_b ]
93
vlog "Checksums are not equal"
97
vlog "Checksums are OK"