Debian Codegraph @

mysql-test/suite/mariabackup/recreate_table_during_backup.result

raw
1 CREATE TABLE t1(i int) ENGINE=INNODB;
2 CREATE TABLE t2(i int) ENGINE=INNODB;
3 CREATE TABLE t3(a CHAR(36)) ENGINE INNODB;
4 INSERT INTO t3 SELECT UUID() FROM seq_1_to_1000;
5 set global innodb_log_checkpoint_now=1;
6 # xtrabackup backup
7 # xtrabackup prepare
8 # shutdown server
9 # remove datadir
10 # xtrabackup move back
11 # restart
12 SELECT COUNT(*) from t1;
13 COUNT(*)
14 100
15 SELECT COUNT(*) from t2;
16 COUNT(*)
17 1000
18 SELECT COUNT(*) from t3;
19 COUNT(*)
20 1000
21 DROP INDEX index_a ON t3;
22 DROP TABLE t1;
23 DROP TABLE t2;
24 DROP TABLE t3;