# Stop MySQL server 1
# Stop MySQL server 2
# Restore 7.6 backup into NDB
# Setup the 7.6 data directory
# Copy zip files to tmp
# Check that the file exists in the working folder
# Unzip the contents
# Rename the extracted root directory for server2
# Unzip again for server1
# Test upgrade on 7.6 data directory on MySQL server 1
Pattern "\[ERROR\]" not found
# Test upgrade on 7.6 data directory on MySQL server 2
Pattern "\[ERROR\]" not found
SHOW TABLES;
Tables_in_test
t1
SELECT engine from information_schema.tables
WHERE table_schema='mysql' and table_name='user';
ENGINE
InnoDB
SHOW TABLES IN db1;
Tables_in_db1
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `a` int(11) NOT NULL,
  `b` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`a`)
) /*!50100 TABLESPACE `ts1` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
SHOW CREATE TABLE db1.t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `a` int(11) NOT NULL,
  `b` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`a`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SELECT * FROM t1;
a	b
1	Solskjaer has won it
SELECT * FROM db1.t1;
a	b
1	Manchester United have
2	Reached the promised land
ALTER TABLE t1 DROP COLUMN b;
SHOW TABLES;
Tables_in_test
t1
SELECT engine from information_schema.tables
WHERE table_schema='mysql' and table_name='user';
ENGINE
InnoDB
SHOW TABLES IN db1;
Tables_in_db1
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `a` int(11) NOT NULL,
  PRIMARY KEY (`a`)
) /*!50100 TABLESPACE `ts1` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
SHOW CREATE TABLE db1.t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `a` int(11) NOT NULL,
  `b` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`a`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SELECT * FROM t1;
a
1
SELECT * FROM db1.t1;
a	b
1	Manchester United have
2	Reached the promised land
DROP TABLE t1;
DROP TABLE db1.t1;
ALTER TABLESPACE ts1
DROP DATAFILE 'ts1_datafile.dat';
DROP TABLESPACE ts1;
DROP LOGFILE GROUP lg1
ENGINE NDB;