1--source include/have_debug.inc
2
3CREATE TABLE t1(i INT PRIMARY KEY auto_increment, a int) ENGINE INNODB;
4INSERT INTO t1(a) SELECT * from seq_1_to_10000;
5SET GLOBAL innodb_log_optimize_ddl=ON;
6
7let $targetdir=$MYSQLTEST_VARDIR/tmp/backup;
8
9let after_copy_test_t1=CREATE INDEX a_ind ON test.t1(a) ALGORITHM=INPLACE;
10echo # xtrabackup backup;
11--disable_result_log
12exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf  --backup  --target-dir=$targetdir  --dbug=+d,mariabackup_events;
13--enable_result_log
14
15--list_files $targetdir/test t1*
16--let before_copy_test_t1=
17
18echo # xtrabackup prepare;
19--disable_result_log
20exec $XTRABACKUP  --prepare --target-dir=$targetdir;
21-- source include/restart_and_restore.inc
22--enable_result_log
23
24# Check that new table is there after restore.
25SELECT COUNT(*) from t1;
26DROP TABLE t1;
27rmdir $targetdir;
28
29