Name | Date | Size | #Lines | LOC | ||
---|---|---|---|---|---|---|
.. | 03-May-2022 | - | ||||
Europe/ | H | 03-May-2022 | - | |||
bug16204175/ | H | 28-Aug-2020 | - | 14 | 13 | |
comp_err/ | H | 03-May-2022 | - | |||
crldir/ | H | 28-Aug-2020 | - | 14 | 13 | |
dd/sdi/ | H | 28-Aug-2020 | - | 109,943 | 109,880 | |
ecdh_dsa_certs/ | H | 28-Aug-2020 | - | 280 | 269 | |
ecdh_rsa_certs/ | H | 28-Aug-2020 | - | 203 | 195 | |
ecdsa_certs/ | H | 28-Aug-2020 | - | 67 | 58 | |
funcs_1/ | H | 03-May-2022 | - | |||
lob/ | H | 03-May-2022 | - | |||
log_corruption/ | H | 03-May-2022 | - | |||
new_certs_for_bad_host/ | H | 28-Aug-2020 | - | 100 | 96 | |
parts/ | H | 03-May-2022 | - | 66 | 61 | |
upgrade/ | H | 03-May-2022 | - | |||
.mylogin.cnf | H A D | 28-Aug-2020 | 65 | 3 | 2 | |
256kb.json | H A D | 28-Aug-2020 | 264.5 KiB | 1 | 1 | |
Index.xml | H A D | 28-Aug-2020 | 170.5 KiB | 1,114 | 993 | |
README_tablespace_portable_win.text | H A D | 28-Aug-2020 | 3.7 KiB | 94 | 73 | |
alter_table.csv | H A D | 28-Aug-2020 | 2.7 KiB | 67 | 66 | |
bad_gis_data.dat | H A D | 28-Aug-2020 | 4 | 2 | 1 | |
bug15328.cnf | H A D | 28-Aug-2020 | 44 | 3 | 2 | |
bug16171518_1.dat | H A D | 28-Aug-2020 | 1.1 KiB | 60 | 54 | |
bug16171518_2.dat | H A D | 28-Aug-2020 | 169 | 13 | 12 | |
bug18311187_account.TRG | H A D | 28-Aug-2020 | 280 | 8 | 7 | |
bug18311187_ins_sum.TRN | H A D | 28-Aug-2020 | 39 | 3 | 2 | |
bug20444737.sql | H A D | 28-Aug-2020 | 31 | 2 | 1 | |
bug30753708.dat | H A D | 28-Aug-2020 | 539 | 32 | 24 | |
bug35469.dat | H A D | 28-Aug-2020 | 45 | 4 | 3 | |
ca-cert-verify-san.pem | H A D | 28-Aug-2020 | 1.3 KiB | 23 | 22 | |
ca-cert-verify.pem | H A D | 28-Aug-2020 | 1.2 KiB | 21 | 20 | |
ca-sha512.pem | H A D | 28-Aug-2020 | 1.1 KiB | 21 | 20 | |
cacert.pem | H A D | 28-Aug-2020 | 4.3 KiB | 80 | 78 | |
client-cert-verify-san.pem | H A D | 28-Aug-2020 | 1.2 KiB | 21 | 20 | |
client-cert.pem | H A D | 28-Aug-2020 | 4.4 KiB | 83 | 81 | |
client-key-verify-san.pem | H A D | 28-Aug-2020 | 1.6 KiB | 28 | 27 | |
client-key.pem | H A D | 28-Aug-2020 | 1.6 KiB | 28 | 27 | |
crl-ca-cert.pem | H A D | 28-Aug-2020 | 4.3 KiB | 81 | 79 | |
crl-client-cert.pem | H A D | 28-Aug-2020 | 4.4 KiB | 82 | 80 | |
crl-client-key.pem | H A D | 28-Aug-2020 | 1.6 KiB | 28 | 27 | |
crl-client-revoked-cert.pem | H A D | 28-Aug-2020 | 4.4 KiB | 82 | 80 | |
crl-client-revoked-key.pem | H A D | 28-Aug-2020 | 1.6 KiB | 28 | 27 | |
crl-client-revoked.crl | H A D | 28-Aug-2020 | 711 | 14 | 13 | |
crl-server-cert.pem | H A D | 28-Aug-2020 | 4.4 KiB | 82 | 80 | |
crl-server-key.pem | H A D | 28-Aug-2020 | 1.6 KiB | 28 | 27 | |
des_key_file | H A D | 28-Aug-2020 | 55 | 5 | 4 | |
expired-ca-key.pem | H A D | 28-Aug-2020 | 1.6 KiB | 28 | 27 | |
expired-ca.pem | H A D | 28-Aug-2020 | 1.4 KiB | 24 | 23 | |
expired-client-cert.pem | H A D | 28-Aug-2020 | 1.2 KiB | 22 | 21 | |
expired-client-key.pem | H A D | 28-Aug-2020 | 1.6 KiB | 28 | 27 | |
expired-server-cert.pem | H A D | 28-Aug-2020 | 1.2 KiB | 22 | 21 | |
expired-server-key.pem | H A D | 28-Aug-2020 | 1.6 KiB | 28 | 27 | |
explicit_undo_32.sql | H A D | 28-Aug-2020 | 2.3 KiB | 36 | 32 | |
hostname_in_grantor.sql | H A D | 28-Aug-2020 | 1.2 KiB | 30 | 23 | |
hostname_in_perfschema.sql | H A D | 28-Aug-2020 | 4.4 KiB | 108 | 86 | |
inconsistent_scan.csv | H A D | 28-Aug-2020 | 19.6 KiB | 203 | 202 | |
init-file-rpl-filter.dat | H A D | 28-Aug-2020 | 481 | 8 | 7 | |
init_file.dat | H A D | 28-Aug-2020 | 1.3 KiB | 46 | 36 | |
initial_v@1o.frm | H A D | 28-Aug-2020 | 433 | 16 | 15 | |
intersect-bug50389.tsv | H A D | 28-Aug-2020 | 21 KiB | 546 | 545 | |
invalid_rsa_public_key.pem | H A D | 28-Aug-2020 | 386 | 9 | 8 | |
latin1.xml | H A D | 28-Aug-2020 | 5.8 KiB | 144 | 126 | |
loaddata1.dat | H A D | 28-Aug-2020 | 56 | 4 | 3 | |
loaddata2.dat | H A D | 28-Aug-2020 | 95 | 6 | 5 | |
loaddata3.dat | H A D | 28-Aug-2020 | 210 | 7 | 6 | |
loaddata4.dat | H A D | 28-Aug-2020 | 85 | 2 | 1 | |
loaddata5.dat | H A D | 28-Aug-2020 | 69 | 4 | 3 | |
loaddata_dq.dat | H A D | 28-Aug-2020 | 46 | 4 | 3 | |
loaddata_pair.dat | H A D | 28-Aug-2020 | 20 | 3 | 2 | |
loaddata_utf8.dat | H A D | 28-Aug-2020 | 63 | 7 | 6 | |
loadxml.dat | H A D | 28-Aug-2020 | 1.4 KiB | 65 | 47 | |
loadxml2.dat | H A D | 28-Aug-2020 | 951 | 20 | 19 | |
mysqldump_57.sql | H A D | 28-Aug-2020 | 367.2 KiB | 884 | 603 | |
old-format-relay-log-win.info | H A D | 28-Aug-2020 | 30 | 5 | 3 | |
old-format-relay-log.info | H A D | 28-Aug-2020 | 30 | 5 | 3 | |
onerow.xml | H A D | 28-Aug-2020 | 339 | 14 | 13 | |
rpl_bug28618.dat | H A D | 28-Aug-2020 | 42 | 4 | 3 | |
rpl_loaddata.dat | H A D | 28-Aug-2020 | 12 | 3 | 2 | |
rpl_loaddata2.dat | H A D | 28-Aug-2020 | 140 | 9 | 8 | |
rpl_mixed.dat | H A D | 28-Aug-2020 | 30 | 4 | 3 | |
rpl_timezone.dat | H A D | 28-Aug-2020 | 30 | 3 | 2 | |
rpl_timezone2.dat | H A D | 28-Aug-2020 | 40 | 3 | 2 | |
rsa_private_key.pem | H A D | 28-Aug-2020 | 3.2 KiB | 52 | 51 | |
rsa_public_key.pem | H A D | 28-Aug-2020 | 800 | 15 | 14 | |
server-cert-sha512.pem | H A D | 28-Aug-2020 | 1.2 KiB | 21 | 20 | |
server-cert-verify-fail.pem | H A D | 28-Aug-2020 | 1.1 KiB | 20 | 19 | |
server-cert-verify-pass.pem | H A D | 28-Aug-2020 | 1.1 KiB | 20 | 19 | |
server-cert-verify-san.pem | H A D | 28-Aug-2020 | 1.4 KiB | 24 | 23 | |
server-cert.pem | H A D | 28-Aug-2020 | 4.5 KiB | 85 | 83 | |
server-key-sha512.pem | H A D | 28-Aug-2020 | 1.6 KiB | 28 | 27 | |
server-key-verify-fail.pem | H A D | 28-Aug-2020 | 1.6 KiB | 28 | 27 | |
server-key-verify-pass.pem | H A D | 28-Aug-2020 | 1.6 KiB | 28 | 27 | |
server-key-verify-san.pem | H A D | 28-Aug-2020 | 1.6 KiB | 28 | 27 | |
server-key.pem | H A D | 28-Aug-2020 | 1.6 KiB | 28 | 27 | |
server-sha1-1024-cert.pem | H A D | 28-Aug-2020 | 879 | 16 | 15 | |
server-sha1-1024-key.pem | H A D | 28-Aug-2020 | 887 | 16 | 15 | |
server8k-cert.pem | H A D | 28-Aug-2020 | 12.4 KiB | 208 | 206 | |
server8k-key.pem | H A D | 28-Aug-2020 | 6.2 KiB | 100 | 99 | |
shutdown.sql | H A D | 28-Aug-2020 | 26 | 3 | 2 | |
slave-relay-bin-win.index | H A D | 28-Aug-2020 | 20 | 2 | 1 | |
slave-relay-bin.index | H A D | 28-Aug-2020 | 20 | 2 | 1 | |
slave-relay-bin_linux.index | H A D | 28-Aug-2020 | 25 | 2 | 1 | |
slave-relay-bin_win.index | H A D | 28-Aug-2020 | 25 | 2 | 1 | |
untrusted-cacert.pem | H A D | 28-Aug-2020 | 2.7 KiB | 54 | 52 | |
warnings_loaddata.dat | H A D | 28-Aug-2020 | 211 | 9 | 8 | |
wl6030.dat | H A D | 28-Aug-2020 | 41 | 6 | 5 | |
wl6030_2.dat | H A D | 28-Aug-2020 | 136 | 10 | 9 | |
words.dat | H A D | 28-Aug-2020 | 581 | 71 | 70 | |
words2.dat | H A D | 28-Aug-2020 | 419 | 51 | 50 | |
x_y_data.csv | H A D | 28-Aug-2020 | 12 | 3 | 2 |
README_tablespace_portable_win.text
1wl#8619 : This readme file is prepared for testing the functionality (portability) of the wl#8619 . 2Test windows --datadir and tablespaces runs on Linux platform. 3Note 1: The --datadir hierarchy and schema name and its hierarchy (Ex: test/tab1.ibd) should be followed 4 5Note 2: For older version of --datadir (Ex: 8.0), it is users responsibility to run upgrade script against the --datadir, once the 6upgrade is successful, you can create a zip file (tablespace_portable_win.zip). You can directly run portability functionality 7with old --datadir (Ex: mysql-8.0). Hence intentionally upgrade step is not added in this testcase. 8 9Note 3: The folder names and tablspace names and my.cnf config file should same as follows, do not change anything, as testcase 10might fail. 11 121) Logon on to any windows machine 13 142) Download the mysql binaries from PB2 (latest version of trunk) 15 163) InitDB/bootstrap the datadir using the following my.cnf config file, here is the command 17 18E:\wl8619\portable\mysql-commercial-9.0.0-dmr-winx64\bin\mysqld.exe --defaults-file=./my.cnf --datadir=../Win-DB/ --basedir=. --initialize-insecure 19 20log_error_verbosity=3 21lower_case_table_names=1 22innodb_log_files_in_group=4 23innodb_log_group_home_dir=../data_home 24innodb_data_home_dir=../data_home 25innodb_undo_directory=../undo_files 26innodb_undo_tablespaces=5 27innodb_data_file_path=data01:20M;data02:20M:autoextend 28 294) start the server with the same my.cnf file and connect with mysql client 30E:\wl8619\portable\mysql-commercial-9.0.0-dmr-winx64\bin\mysqld.exe --defaults-file=./my.cnf --datadir=../Win-DB/ --basedir=. -u root 31 325) Run following DDLs 33 34Note : Do replace 'xxx' in DDL statements with target location of that machine 35 36CREATE DATABASE test; 37use test; 38CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' Engine=InnoDB; 39CREATE TABLE tab1(c1 int, c2 varchar(10)) TABLESPACE=ts1; 40INSERT INTO tab1 VALUES(1, 'VISH'); 41CREATE TABLE tab2(c1 int , c2 varchar(10)) Engine=InnoDB; 42INSERT INTO tab2 VALUES(2, 'VISH'); 43CREATE INDEX ix1 ON tab1(c2) USING BTREE; 44CREATE INDEX ix2 ON tab2(c2) ; 45 46create table tab3 ( 47empno int, 48ename varchar(30), 49sal numeric(3)) 50engine=InnoDB row_format=compressed 51partition by hash(empno) ( 52partition P0 DATA DIRECTORY = 'E:\\xxx\\xxx\\datadir1', 53partition P1 DATA DIRECTORY = 'E:\\xxx\\xxx\\datadir1'); 54 55CREATE INDEX ix1 ON tab3(ename) USING BTREE; 56INSERT INTO tab3 VALUES (100,'VISWANATH',100); 57INSERT INTO tab3 VALUES (300,'VISWANATH',100); 58 59CREATE TABLE purchase ( 60 `id` int(11) DEFAULT NULL, 61 `purchased` date DEFAULT NULL 62) ENGINE=InnoDB DEFAULT CHARSET=latin1 63PARTITION BY RANGE ( YEAR(purchased)) 64SUBPARTITION BY HASH ( TO_DAYS(purchased)) 65(PARTITION p0 VALUES LESS THAN (1990) 66 (SUBPARTITION s0 DATA DIRECTORY = 'E:\\xxx\\xxx\\part0' ENGINE = InnoDB, 67 SUBPARTITION s1 DATA DIRECTORY = 'E:\\xxx\\xxx\\part1' ENGINE = InnoDB), 68 PARTITION p1 VALUES LESS THAN (2000) 69 (SUBPARTITION s2 DATA DIRECTORY = 'E:\\xxx\\xxx\\part2' ENGINE = InnoDB, 70 SUBPARTITION s3 DATA DIRECTORY = 'E:\\xxx\\xxx\\part3' ENGINE = InnoDB)); 71 72INSERT INTO purchase VALUES(1,'1980-05-31'); 73INSERT INTO purchase VALUES(2,'1999-05-31'); 74INSERT INTO purchase VALUES(3,'1998-05-31'); 75INSERT INTO purchase VALUES(4,'1979-05-31'); 76INSERT INTO purchase VALUES(5,'1978-05-31'); 77INSERT INTO purchase VALUES(6,'1997-05-31'); 78 79CREATE TABLESPACE ts2 ADD DATAFILE 'E:\\xxx\\xxx\\undo_files\\ts2.ibd' Engine=InnoDB; 80CREATE TABLE tab4(c1 int, c2 varchar(10)) TABLESPACE=ts2; 81INSERT INTO tab4 VALUES(1, 'VISH'); 82 836) Shutdown the server (no crash or KILL -9) 84 857) zip entire --datadir files (following list of folders) 86 87--datadir (Win-DB) 88--innodb_undo_directory (undo_files) 89--innodb_data_home_dir (data_home) 90--innodb_log_group_home_dir (data_home) 91part0,part1,part2,part3,datadir1 92 938) Copy that zip file into mysql-test/std_data location of MTR home DIR 94