# 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 account t1 SHOW TRIGGERS; Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation ins_transaction INSERT account SET @deposits = @deposits + IF(NEW.amount>0,NEW.amount,0), @withdrawals = @withdrawals + IF(NEW.amount<0,-NEW.amount,0) BEFORE # ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION root@localhost latin1 latin1_swedish_ci latin1_swedish_ci ins_sum INSERT account SET @sum = @sum + NEW.amount BEFORE # ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION root@localhost latin1 latin1_swedish_ci latin1_swedish_ci SHOW TABLES; Tables_in_test account t1 SHOW TRIGGERS; Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation ins_transaction INSERT account SET @deposits = @deposits + IF(NEW.amount>0,NEW.amount,0), @withdrawals = @withdrawals + IF(NEW.amount<0,-NEW.amount,0) BEFORE # ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION root@localhost latin1 latin1_swedish_ci latin1_swedish_ci ins_sum INSERT account SET @sum = @sum + NEW.amount BEFORE # ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION root@localhost latin1 latin1_swedish_ci latin1_swedish_ci SET @sum = 0; SET @deposits = 0; SET @withdrawals = 0; INSERT INTO account VALUES(137,14.98),(141,1937.50),(97,-100.00); SELECT * FROM account; acct_num amount 137 14.98 141 1937.50 97 -100.00 SELECT @sum AS 'Sum', @deposits AS 'Deposits', @withdrawals AS 'Withdrawals'; Sum Deposits Withdrawals 1852.48 1952.48 100.00 DROP TABLE t1, account;