Debian Codegraph @

mysql-test/suite/s3/mysqldump.test

raw
1 --source include/have_s3.inc
2 --source create_database.inc
3
4 create table t1 (pk int primary key, a int);
5 insert into t1 values (1,1),(2,2),(3,3),(4,4);
6 alter table t1 engine=S3;
7
8 --echo #####
9 --echo # mysqldump with --copy-s3-tables=0 (by default)
10 --echo ###
11 --exec $MYSQL_DUMP --compact $database
12 --echo #####
13 --echo # mysqldump with --copy-s3-tables=0 (by default) XML
14 --echo ###
15 --replace_regex /[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}(.[0-9]{2})*/--TIME--/
16 --replace_result $database database
17 --exec $MYSQL_DUMP --compact -X $database
18 --echo #####
19 --echo # mysqldump with --copy-s3-tables=1
20 --echo ###
21 --exec $MYSQL_DUMP --compact --copy-s3-tables=1 $database
22 --echo #####
23 --echo # mysqldump with --copy-s3-tables=1 XML
24 --echo ###
25 --replace_regex /[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}(.[0-9]{2})*/--TIME--/
26 --replace_result $database database
27 --exec $MYSQL_DUMP --compact --copy-s3-tables=1 -X $database
28
29 drop table t1;
30 #
31 # clean up
32 #
33 --source drop_database.inc