1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
|
#
# Import regular and partitioned tablespaces exported from 5.7 after a restart.
#
CREATE SCHEMA `import80`;
USE `import80`;
CREATE TABLE `t1` (`c1` INT);
CREATE TABLE `t2` (`c1` INT PRIMARY KEY, `c2` INT) DATA DIRECTORY ='MYSQL_TMP_DIR/external_dir';
CREATE TABLE `t3` (`c1` INT) PARTITION BY KEY (`c1`) PARTITIONS 2;
CREATE TABLE `t4` (`c1` INT PRIMARY KEY, `c2` INT) DATA DIRECTORY ='MYSQL_TMP_DIR/external_dir' PARTITION BY HASH (`c1`) PARTITIONS 2;
CREATE TABLE `t5` (`c1` INT);
INSERT INTO `t5` values (1);
CREATE TABLE `t6` (`c1` INT PRIMARY KEY, `c2` INT) DATA DIRECTORY ='MYSQL_TMP_DIR/external_dir';
INSERT INTO `t6` values (1, 1);
CREATE TABLE `t7` (`c1` INT) PARTITION BY KEY (`c1`) PARTITIONS 2;
INSERT INTO `t7` values (1);
CREATE TABLE `t8` (`c1` INT PRIMARY KEY, `c2` INT) DATA DIRECTORY ='MYSQL_TMP_DIR/external_dir' PARTITION BY HASH (`c1`) PARTITIONS 2;
INSERT INTO `t8` values (1, 1);
FLUSH TABLES `t5`, `t6`, `t7`, `t8` FOR EXPORT;
# Copy cfg and ibd files for `t5` to MYSQL_TMP_DIR/export80.
# Copy cfg and ibd files for `t6` to MYSQL_TMP_DIR/export80.
# Copy cfg and ibd files for `t7` to MYSQL_TMP_DIR/export80.
# Copy cfg and ibd files for `t8` to MYSQL_TMP_DIR/export80.
UNLOCK TABLES;
ALTER TABLE `t1` DISCARD TABLESPACE;
ALTER TABLE `t2` DISCARD TABLESPACE;
ALTER TABLE `t3` DISCARD TABLESPACE;
ALTER TABLE `t4` DISCARD TABLESPACE;
ALTER TABLE `t5` DISCARD TABLESPACE;
ALTER TABLE `t6` DISCARD TABLESPACE;
ALTER TABLE `t7` DISCARD TABLESPACE;
ALTER TABLE `t8` DISCARD TABLESPACE;
# Unzip exported 5.7 partitioned tables to MYSQL_TMP_DIR.
# Copy exported v5.7 t1 files to MYSQLD_DATADIR/import80.
# Copy exported v5.7 t2 files to MYSQL_TMP_DIR/external_dir/import80.
# Copy exported v5.7 t3 files to MYSQLD_DATADIR/import80.
# Copy exported v5.7 t4 files to MYSQL_TMP_DIR/external_dir/import80.
# Copy exported v8.0 t5 files to MYSQLD_DATADIR/import80.
# Copy exported v8.0 t6 files to MYSQL_TMP_DIR/external_dir/import80.
# Copy exported v8.0 t7 files to MYSQLD_DATADIR/import80.
# Copy exported v8.0 t8 files to MYSQL_TMP_DIR/external_dir/import80.
# restart
ALTER TABLE `t1` IMPORT TABLESPACE;
select * from t1;
c1
1
ALTER TABLE `t2` IMPORT TABLESPACE;
select * from t2;
c1 c2
1 1
ALTER TABLE `t3` IMPORT TABLESPACE;
select * from t3;
c1
1
ALTER TABLE `t4` IMPORT TABLESPACE;
select * from t4;
c1 c2
1 1
ALTER TABLE `t5` IMPORT TABLESPACE;
select * from t5;
c1
1
ALTER TABLE `t6` IMPORT TABLESPACE;
select * from t6;
c1 c2
1 1
ALTER TABLE `t7` IMPORT TABLESPACE;
select * from t7;
c1
1
ALTER TABLE `t8` IMPORT TABLESPACE;
select * from t8;
c1 c2
1 1
# Cleanup
DROP TABLE `t1`, `t2`, t3, t4, `t5`, `t6`, t7, t8;
USE `test`;
DROP SCHEMA `import80`;
|
