⚝
One Hat Cyber Team
⚝
Your IP:
216.73.216.124
Server IP:
50.28.103.30
Server:
Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software:
nginx/1.28.0
PHP Version:
8.3.12
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
www
/
server
/
mysql
/
mysql-test
/
suite
/
innodb
/
r
/
View File Name :
import_compress_encrypt.result
# # Bug#31313533 : IMPORT FAILS FOR ENCRYPT AND COMPRESSION ENABLED TDE TABLES # # SETUP # RESTART WITH KEYRING PLUGIN # restart: --early-plugin-load=keyring_file=keyring_file.so --loose-keyring_file_data=MYSQL_TMP_DIR/mysecret_keyring KEYRING_PLUGIN_OPT # Test 1 : Check that EXPORT and IMPORT is working fine on same FS CREATE TABLE t1(c1 int NOT NULL AUTO_INCREMENT, c2 varchar(65000) DEFAULT NULL, c3 varchar(255) GENERATED ALWAYS AS (substr(c2,2,100)) STORED, c4 varchar(255) GENERATED ALWAYS AS (substr(c2,10,200)) VIRTUAL, b bit(64) DEFAULT NULL, p_c1 bigint DEFAULT NULL, PRIMARY KEY (c1)) ENGINE=Innodb AUTO_INCREMENT=50001 DEFAULT CHARSET=latin1 COMPRESSION='zlib' ENCRYPTION='Y'; SELECT c1, SUBSTRING(c2, 10, 10), SUBSTRING(c3, 10, 10), SUBSTRING(c4, 10, 10), b FROM t1 ORDER BY c1 limit 10; c1 SUBSTRING(c2, 10, 10) SUBSTRING(c3, 10, 10) SUBSTRING(c4, 10, 10) b 50001 l��>�!u�w l��>�!u�w� w���[�s� 50002 l��>�!u�w l��>�!u�w� w���[�s� 50003 l��>�!u�w l��>�!u�w� w���[�s� 50004 l��>�!u�w l��>�!u�w� w���[�s� 50005 l��>�!u�w l��>�!u�w� w���[�s� 50006 l��>�!u�w l��>�!u�w� w���[�s� 50007 l��>�!u�w l��>�!u�w� w���[�s� 50008 l��>�!u�w l��>�!u�w� w���[�s� 50009 l��>�!u�w l��>�!u�w� w���[�s� 50010 l��>�!u�w l��>�!u�w� w���[�s� # Flush tables for export FLUSH TABLES t1 FOR EXPORT; # Copy .cfp .cfg .ibd file to temp UNLOCK TABLES; DROP TABLE t1; CREATE TABLE t1(c1 int NOT NULL AUTO_INCREMENT, c2 varchar(65000) DEFAULT NULL, c3 varchar(255) GENERATED ALWAYS AS (substr(c2,2,100)) STORED, c4 varchar(255) GENERATED ALWAYS AS (substr(c2,10,200)) VIRTUAL, b bit(64) DEFAULT NULL, p_c1 bigint DEFAULT NULL, PRIMARY KEY (c1)) ENGINE=Innodb AUTO_INCREMENT=50001 DEFAULT CHARSET=latin1 COMPRESSION='zlib' ENCRYPTION='Y'; ALTER TABLE t1 DISCARD TABLESPACE; # Copy .cfp/.cfg and .ibd files from temp to datadir # Start import ALTER TABLE t1 IMPORT TABLESPACE; SELECT c1, SUBSTRING(c2, 10, 10), SUBSTRING(c3, 10, 10), SUBSTRING(c4, 10, 10), b FROM t1 ORDER BY c1 limit 10; c1 SUBSTRING(c2, 10, 10) SUBSTRING(c3, 10, 10) SUBSTRING(c4, 10, 10) b 50001 l��>�!u�w l��>�!u�w� w���[�s� 50002 l��>�!u�w l��>�!u�w� w���[�s� 50003 l��>�!u�w l��>�!u�w� w���[�s� 50004 l��>�!u�w l��>�!u�w� w���[�s� 50005 l��>�!u�w l��>�!u�w� w���[�s� 50006 l��>�!u�w l��>�!u�w� w���[�s� 50007 l��>�!u�w l��>�!u�w� w���[�s� 50008 l��>�!u�w l��>�!u�w� w���[�s� 50009 l��>�!u�w l��>�!u�w� w���[�s� 50010 l��>�!u�w l��>�!u�w� w���[�s� # Cleanup DROP TABLE t1; # Test 2 : Check that EXPORT and IMPORT is working fine on different FS # Copy and unzip the dir having cfg/cfg/ibd file from a different FS Block Size CREATE TABLE t1(c1 int NOT NULL AUTO_INCREMENT, c2 varchar(65000) DEFAULT NULL, c3 varchar(255) GENERATED ALWAYS AS (substr(c2,2,100)) STORED, c4 varchar(255) GENERATED ALWAYS AS (substr(c2,10,200)) VIRTUAL, b bit(64) DEFAULT NULL, p_c1 bigint DEFAULT NULL, PRIMARY KEY (c1)) ENGINE=Innodb AUTO_INCREMENT=50001 DEFAULT CHARSET=latin1 COMPRESSION='zlib' ENCRYPTION='Y'; ALTER TABLE t1 DISCARD TABLESPACE; # Copy .cfp/.cfg and .ibd files from temp to datadir # Start import ALTER TABLE t1 IMPORT TABLESPACE; SELECT c1, SUBSTRING(c2, 10, 10), SUBSTRING(c3, 10, 10), SUBSTRING(c4, 10, 10), b FROM t1 ORDER BY c1 limit 10; c1 SUBSTRING(c2, 10, 10) SUBSTRING(c3, 10, 10) SUBSTRING(c4, 10, 10) b 50001 l��>�!u�w l��>�!u�w� w���[�s� 50002 l��>�!u�w l��>�!u�w� w���[�s� 50003 l��>�!u�w l��>�!u�w� w���[�s� 50004 l��>�!u�w l��>�!u�w� w���[�s� 50005 l��>�!u�w l��>�!u�w� w���[�s� 50006 l��>�!u�w l��>�!u�w� w���[�s� 50007 l��>�!u�w l��>�!u�w� w���[�s� 50008 l��>�!u�w l��>�!u�w� w���[�s� 50009 l��>�!u�w l��>�!u�w� w���[�s� 50010 l��>�!u�w l��>�!u�w� w���[�s� # Cleanup DROP TABLE t1; # Remove copied files # Test 3 : Check that IMPORT works fine from previous version on same FS # Copy and unzip the dir having cfg/cfg/ibd file from previous version. CREATE TABLE t1(c1 int NOT NULL AUTO_INCREMENT, c2 varchar(65000) DEFAULT NULL, c3 varchar(255) GENERATED ALWAYS AS (substr(c2,2,100)) STORED, c4 varchar(255) GENERATED ALWAYS AS (substr(c2,10,200)) VIRTUAL, b bit(64) DEFAULT NULL, p_c1 bigint DEFAULT NULL, PRIMARY KEY (c1)) ENGINE=Innodb AUTO_INCREMENT=50001 DEFAULT CHARSET=latin1 COMPRESSION='zlib' ENCRYPTION='Y'; ALTER TABLE t1 DISCARD TABLESPACE; # Copy .cfp/.cfg and .ibd files from temp to datadir # Start import ALTER TABLE t1 IMPORT TABLESPACE; SELECT c1, SUBSTRING(c2, 10, 10), SUBSTRING(c3, 10, 10), SUBSTRING(c4, 10, 10), b FROM t1 ORDER BY c1 limit 10; c1 SUBSTRING(c2, 10, 10) SUBSTRING(c3, 10, 10) SUBSTRING(c4, 10, 10) b 50001 l��>�!u�w l��>�!u�w� w���[�s� 50002 l��>�!u�w l��>�!u�w� w���[�s� 50003 l��>�!u�w l��>�!u�w� w���[�s� 50004 l��>�!u�w l��>�!u�w� w���[�s� 50005 l��>�!u�w l��>�!u�w� w���[�s� 50006 l��>�!u�w l��>�!u�w� w���[�s� 50007 l��>�!u�w l��>�!u�w� w���[�s� 50008 l��>�!u�w l��>�!u�w� w���[�s� 50009 l��>�!u�w l��>�!u�w� w���[�s� 50010 l��>�!u�w l��>�!u�w� w���[�s� # Cleanup DROP TABLE t1; # Remove copied files