← Back to branch summary

~jlukas79/+junk/mysql-server

« back to all changes in this revision

Viewing changes to mysql-test/t/backup_compression.test

manual merge 6.0-main --> 6.0-bka-review

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/backup_compression.test
 
1
--source include/not_embedded.inc
 
2
--source include/have_compress.inc
 
3
 
 
4
CREATE DATABASE db1;
 
5
 
 
6
CREATE TABLE db1.t1(a INT);
 
7
replace_column 1 #;
 
8
BACKUP DATABASE db1 TO 'db1.bak.gz' WITH COMPRESSION;
 
9
 
 
10
CREATE TABLE db1.t2(a INT);
 
11
replace_column 1 #;
 
12
BACKUP DATABASE db1 TO 'db2.bak.gz' WITH COMPRESSION COMPRESSION_ALGORITHM=gzip;
 
13
 
 
14
replace_column 1 #;
 
15
RESTORE FROM 'db1.bak.gz';
 
16
SHOW TABLES FROM db1;
 
17
 
 
18
replace_column 1 #;
 
19
RESTORE FROM 'db2.bak.gz';
 
20
SHOW TABLES FROM db1;
 
21
 
 
22
DROP DATABASE db1;
 
23
--remove_file $MYSQLTEST_VARDIR/master-data/db1.bak.gz
 
24
--remove_file $MYSQLTEST_VARDIR/master-data/db2.bak.gz