| 1 |
use test; |
| 2 |
create table test.t1 (a varchar(20) not null, |
| 3 |
b varchar(20) not null, |
| 4 |
c varchar(20), |
| 5 |
d varchar(20), |
| 6 |
e text, |
| 7 |
primary key(a,b)) engine=ndb; |
| 8 |
insert into test.t1 values |
| 9 |
("1a","1b",NULL,"1d", repeat('01WIFUA',1000)), |
| 10 |
("2a","2b",NULL,"2d", repeat('02WIFUA',1000)), |
| 11 |
("3a","3b",NULL,"3d", repeat('03WIFUA',1000)), |
| 12 |
("4a","4b",NULL,"4d", repeat('04WIFUA',1000)), |
| 13 |
("5a","5b",NULL,"5d", repeat('05WIFUA',1000)), |
| 14 |
("6a","6b",NULL,"6d", repeat('06WIFUA',1000)), |
| 15 |
("7a","7b",NULL,"7d", repeat('07WIFUA',1000)), |
| 16 |
("8a","8b",NULL,"8d", repeat('08WIFUA',1000)), |
| 17 |
("9a","9b",NULL,"9d", repeat('09WIFUA',1000)), |
| 18 |
("10a","10b",NULL,"10d", repeat('10WIFUA',1000)), |
| 19 |
("11a","11b",NULL,"11d", repeat('11WIFUA',1000)), |
| 20 |
("12a","12b",NULL,"12d", repeat('12WIFUA',1000)), |
| 21 |
("13a","13b",NULL,"13d", repeat('13WIFUA',1000)), |
| 22 |
("14a","14b",NULL,"14d", repeat('14WIFUA',1000)), |
| 23 |
("15a","15b",NULL,"15d", repeat('15WIFUA',1000)), |
| 24 |
("16a","16b",NULL,"16d", repeat('16WIFUA',1000)); |
| 25 |
Stall backup completion |
| 26 |
Run backup |
| 27 |
Starting backup |
| 28 |
Backup started |
| 29 |
Make some changes which will be logged... |
| 30 |
insert into test.t1 values |
| 31 |
("17a","17b",NULL,"17d", repeat('17WIFUA',1000)), |
| 32 |
("18a","18b",NULL,"18d", repeat('18WIFUA',1000)), |
| 33 |
("19a","19b",NULL,"19d", repeat('19WIFUA',1000)); |
| 34 |
update test.t1 set d=concat(d, "-modified"); |
| 35 |
delete from test.t1 where a in ("5a","18a"); |
| 36 |
Allow backup to complete... |
| 37 |
Waiting for backup to complete |
| 38 |
Backup completed |
| 39 |
delete from test.t1; |
| 40 |
# Normal restore using slices |
| 41 |
select a,b,c,d,length(e), right(e, 7) from test.t1 order by a,b; |
| 42 |
a b c d length(e) right(e, 7) |
| 43 |
10a 10b NULL 10d-modified 7000 10WIFUA |
| 44 |
11a 11b NULL 11d-modified 7000 11WIFUA |
| 45 |
12a 12b NULL 12d-modified 7000 12WIFUA |
| 46 |
13a 13b NULL 13d-modified 7000 13WIFUA |
| 47 |
14a 14b NULL 14d-modified 7000 14WIFUA |
| 48 |
15a 15b NULL 15d-modified 7000 15WIFUA |
| 49 |
16a 16b NULL 16d-modified 7000 16WIFUA |
| 50 |
17a 17b NULL 17d-modified 7000 17WIFUA |
| 51 |
19a 19b NULL 19d-modified 7000 19WIFUA |
| 52 |
1a 1b NULL 1d-modified 7000 01WIFUA |
| 53 |
2a 2b NULL 2d-modified 7000 02WIFUA |
| 54 |
3a 3b NULL 3d-modified 7000 03WIFUA |
| 55 |
4a 4b NULL 4d-modified 7000 04WIFUA |
| 56 |
6a 6b NULL 6d-modified 7000 06WIFUA |
| 57 |
7a 7b NULL 7d-modified 7000 07WIFUA |
| 58 |
8a 8b NULL 8d-modified 7000 08WIFUA |
| 59 |
9a 9b NULL 9d-modified 7000 09WIFUA |
| 60 |
drop table test.t1; |
| 61 |
# Restore with staging conversions + slices |
| 62 |
create table test.t1 (a varchar(20) not null, |
| 63 |
b varchar(20) not null, |
| 64 |
c text, |
| 65 |
d text, |
| 66 |
e text, |
| 67 |
primary key(a,b)) engine=ndb; |
| 68 |
select a,b,c,d,length(e), right(e, 7) from test.t1 order by a,b; |
| 69 |
a b c d length(e) right(e, 7) |
| 70 |
10a 10b NULL 10d-modified 7000 10WIFUA |
| 71 |
11a 11b NULL 11d-modified 7000 11WIFUA |
| 72 |
12a 12b NULL 12d-modified 7000 12WIFUA |
| 73 |
13a 13b NULL 13d-modified 7000 13WIFUA |
| 74 |
14a 14b NULL 14d-modified 7000 14WIFUA |
| 75 |
15a 15b NULL 15d-modified 7000 15WIFUA |
| 76 |
16a 16b NULL 16d-modified 7000 16WIFUA |
| 77 |
17a 17b NULL 17d-modified 7000 17WIFUA |
| 78 |
19a 19b NULL 19d-modified 7000 19WIFUA |
| 79 |
1a 1b NULL 1d-modified 7000 01WIFUA |
| 80 |
2a 2b NULL 2d-modified 7000 02WIFUA |
| 81 |
3a 3b NULL 3d-modified 7000 03WIFUA |
| 82 |
4a 4b NULL 4d-modified 7000 04WIFUA |
| 83 |
6a 6b NULL 6d-modified 7000 06WIFUA |
| 84 |
7a 7b NULL 7d-modified 7000 07WIFUA |
| 85 |
8a 8b NULL 8d-modified 7000 08WIFUA |
| 86 |
9a 9b NULL 9d-modified 7000 09WIFUA |
| 87 |
drop table test.t1; |