Debian Codegraph @

mysql-test/suite/encryption/r/compressed_import_tablespace.result

raw
1 CREATE TABLE t1 (id INT NOT NULL PRIMARY KEY, a VARCHAR(255)) ENGINE=InnoDB ROW_FORMAT=COMPRESSED ENCRYPTED=YES;
2 INSERT INTO t1 VALUES(1, repeat('Nesamani', 10));
3 SELECT COUNT(*) FROM t1;
4 COUNT(*)
5 1
6 SHOW CREATE TABLE t1;
7 Table Create Table
8 t1 CREATE TABLE `t1` (
9 `id` int(11) NOT NULL,
10 `a` varchar(255) DEFAULT NULL,
11 PRIMARY KEY (`id`)
12 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci ROW_FORMAT=COMPRESSED `ENCRYPTED`=YES
13 # Wait max 10 min for key encryption threads to encrypt all spaces
14 db.opt
15 t1.frm
16 t1.ibd
17 FLUSH TABLES t1 FOR EXPORT;
18 backup: t1
19 db.opt
20 t1.cfg
21 t1.frm
22 t1.ibd
23 UNLOCK TABLES;
24 DROP TABLE t1;
25 CREATE TABLE t1 (id INT NOT NULL PRIMARY KEY, a VARCHAR(255)) ENGINE=InnoDB ROW_FORMAT=COMPRESSED ENCRYPTED=YES;
26 ALTER TABLE t1 DISCARD TABLESPACE;
27 restore: t1 .ibd and .cfg files
28 ALTER TABLE t1 IMPORT TABLESPACE;
29 SELECT COUNT(*) FROM t1;
30 COUNT(*)
31 1
32 SHOW CREATE TABLE t1;
33 Table Create Table
34 t1 CREATE TABLE `t1` (
35 `id` int(11) NOT NULL,
36 `a` varchar(255) DEFAULT NULL,
37 PRIMARY KEY (`id`)
38 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci ROW_FORMAT=COMPRESSED `ENCRYPTED`=YES
39 DROP TABLE t1;