mirror of
https://github.com/MariaDB/server.git
synced 2025-02-12 00:15:35 +01:00
33 lines
1,014 B
Text
33 lines
1,014 B
Text
--source include/have_s3.inc
|
|
--source create_database.inc
|
|
|
|
create table t1 (pk int primary key, a int);
|
|
insert into t1 values (1,1),(2,2),(3,3),(4,4);
|
|
alter table t1 engine=S3;
|
|
|
|
--echo #####
|
|
--echo # mysqldump with --copy-s3-tables=0 (by default)
|
|
--echo ###
|
|
--exec $MYSQL_DUMP --compact $database
|
|
--echo #####
|
|
--echo # mysqldump with --copy-s3-tables=0 (by default) XML
|
|
--echo ###
|
|
--replace_regex /[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}(.[0-9]{2})*/--TIME--/
|
|
--replace_result $database database
|
|
--exec $MYSQL_DUMP --compact -X $database
|
|
--echo #####
|
|
--echo # mysqldump with --copy-s3-tables=1
|
|
--echo ###
|
|
--exec $MYSQL_DUMP --no-autocommit=0 --compact --copy-s3-tables=1 $database
|
|
--echo #####
|
|
--echo # mysqldump with --copy-s3-tables=1 XML
|
|
--echo ###
|
|
--replace_regex /[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}(.[0-9]{2})*/--TIME--/
|
|
--replace_result $database database
|
|
--exec $MYSQL_DUMP --compact --copy-s3-tables=1 -X $database
|
|
|
|
drop table t1;
|
|
#
|
|
# clean up
|
|
#
|
|
--source drop_database.inc
|