MySQL 8 Cookbook

Getting ready

1. Check for obsolete datatypes or triggers that have a missing or empty definer or an invalid creation context:

shell> sudo mysqlcheck -u root -p --all-databases --check-upgrade

2. There must be no partitioned tables that use a storage engine that does not have native partitioning support. To identify these tables, execute this query:

shell> SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE ENGINE NOT IN ('innodb', 'ndbcluster') AND CREATE_OPTIONS LIKE '%partitioned%';

If there are any of these tables, change them to InnoDB:

mysql> ALTER TABLE table_name ENGINE = INNODB;

Or remove the partitioning:

mysql> ALTER TABLE table_name REMOVE PARTITIONING;

3. There must be no tables in the MySQL 5.7 mysql system database ...