1
DROP DATABASE IF EXISTS bup_nodata;
2
DROP DATABASE IF EXISTS bup_data;
4
CREATE DATABASE bup_nodata;
5
CREATE DATABASE bup_data;
6
CREATE TABLE bup_data.myisam1 (a int, b char(30)) ENGINE=MYISAM;
7
CREATE TABLE bup_data.myisam2 (a int, b char(30)) ENGINE=MYISAM;
8
CREATE TABLE bup_data.myisam3 (a int, b char(30)) ENGINE=MYISAM;
9
CREATE TABLE bup_data.f1 (
10
`id` int(20) NOT NULL,
11
`group` int NOT NULL default 0,
12
`batch` InT NOT NULL default 0,
13
`qty` int NOT NULL default 0,
14
`name` varchar(32) NOT NULL default ''
16
DEFAULT CHARSET=latin1;
17
CREATE TABLE bup_nodata.merge1 (a int, b char(30))
18
ENGINE=MERGE UNION=(bup_data.myisam1, bup_data.myisam2, bup_data.myisam3);
19
CREATE TABLE bup_nodata.f1 (
20
`id` int(20) NOT NULL,
21
`group` int NOT NULL default 0,
22
`batch` InT NOT NULL default 0,
23
`qty` int NOT NULL default 0,
24
`name` varchar(32) NOT NULL default ''
26
ENGINE="FEDERATED" DEFAULT CHARSET=latin1
27
CONNECTION='mysql://root@127.0.0.1:MASTER_PORT/bup_data/f1';
28
CREATE TABLE bup_nodata.b1 (a int, b int, c char(10)) ENGINE=BLACKHOLE;
29
CREATE TABLE bup_nodata.e1 (
30
Period smallint(4) unsigned zerofill DEFAULT '0000' NOT NULL,
31
Vapor_period smallint(4) unsigned DEFAULT '0' NOT NULL
34
INSERT INTO bup_data.myisam1 VALUES (11, 'table 1');
35
INSERT INTO bup_data.myisam1 VALUES (12, 'table 1');
36
INSERT INTO bup_data.myisam1 VALUES (13, 'table 1');
37
INSERT INTO bup_data.myisam2 VALUES (21, 'table 2');
38
INSERT INTO bup_data.myisam2 VALUES (22, 'table 2');
39
INSERT INTO bup_data.myisam2 VALUES (23, 'table 2');
40
INSERT INTO bup_data.myisam3 VALUES (31, 'table 3');
41
INSERT INTO bup_data.myisam3 VALUES (32, 'table 3');
42
INSERT INTO bup_data.myisam3 VALUES (33, 'table 3');
43
INSERT INTO bup_data.f1 (id, name) VALUES (1, 'foo');
44
INSERT INTO bup_data.f1 (id, name) VALUES (2, 'fee');
45
INSERT INTO bup_data.f1 (id, `group`) VALUES (3, 42);
46
INSERT INTO bup_data.f1 (id, `batch`) VALUES (4, 23);
47
INSERT INTO bup_data.f1 (id, `qty`) VALUES (5, 1);
49
SHOW FULL TABLES FROM bup_data;
50
Tables_in_bup_data Table_type
55
SHOW FULL TABLES FROM bup_nodata;
56
Tables_in_bup_nodata Table_type
61
SELECT * FROM bup_nodata.merge1;
72
SELECT * FROM bup_nodata.f1;
73
id group batch qty name
79
SELECT * FROM bup_nodata.b1;
81
SELECT * FROM bup_nodata.e1;
83
BACKUP DATABASE bup_data TO 'bup_data.bak';
86
BACKUP DATABASE bup_nodata TO 'bup_nodata.bak';
90
SHOW FULL TABLES FROM bup_data;
91
Tables_in_bup_data Table_type
96
SHOW FULL TABLES FROM bup_nodata;
97
Tables_in_bup_nodata Table_type
102
SELECT * FROM bup_nodata.merge1;
113
SELECT * FROM bup_nodata.f1;
114
id group batch qty name
120
SELECT * FROM bup_nodata.b1;
122
SELECT * FROM bup_nodata.e1;
124
DROP DATABASE bup_data;
126
SHOW FULL TABLES FROM bup_nodata;
127
Tables_in_bup_nodata Table_type
132
SELECT * FROM bup_nodata.merge1;
133
ERROR 42S02: Table 'bup_data.myisam1' doesn't exist
134
SELECT * FROM bup_nodata.f1;
135
Got one of the listed errors
136
SELECT * FROM bup_nodata.b1;
138
SELECT * FROM bup_nodata.e1;
140
DROP DATABASE bup_nodata;
141
Restoring nodata database.
142
RESTORE FROM 'bup_nodata.bak';
146
SHOW FULL TABLES FROM bup_nodata;
147
Tables_in_bup_nodata Table_type
152
SELECT * FROM bup_nodata.merge1;
153
ERROR 42S02: Table 'bup_data.myisam1' doesn't exist
154
SELECT * FROM bup_nodata.f1;
155
Got one of the listed errors
156
SELECT * FROM bup_nodata.b1;
158
SELECT * FROM bup_nodata.e1;
160
Restoring data database.
161
RESTORE FROM 'bup_data.bak';
165
SHOW FULL TABLES FROM bup_data;
166
Tables_in_bup_data Table_type
171
SHOW FULL TABLES FROM bup_nodata;
172
Tables_in_bup_nodata Table_type
177
SELECT * FROM bup_nodata.merge1;
188
SELECT * FROM bup_nodata.f1;
189
id group batch qty name
195
SELECT * FROM bup_nodata.b1;
197
SELECT * FROM bup_nodata.e1;
199
DROP DATABASE bup_data;
200
DROP DATABASE bup_nodata;