mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 19:06:14 +01:00
0c55d854fe
Problem: ======== mariabackup --prepare fails to write the pages in encrypted format. This issue happens only for default encrypted table when innodb_encrypt_tables variable is enabled. Fix: ==== backup process should write the value of innodb_encrypt_tables variable in configuration file. prepare should enable the variable based on configuration file.
14 lines
355 B
Text
14 lines
355 B
Text
CREATE TABLE t1(c VARCHAR(128)) ENGINE INNODB;
|
|
insert into t1 values(repeat('a',100));
|
|
select @@innodb_encrypt_tables;
|
|
@@innodb_encrypt_tables
|
|
ON
|
|
# xtrabackup backup
|
|
# xtrabackup prepare export
|
|
# restart
|
|
ALTER TABLE t1 DISCARD TABLESPACE;
|
|
ALTER TABLE t1 IMPORT TABLESPACE;
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|