Preparing Your Installation for Upgrade Any table reported by the query must be altered to use  InnoDB  or be made nonpartitioned. To change a table storage engine to  InnoDB , execute this statement: For information about converting  MyISAM  tables to  InnoDB , see Section 15.6.1.5, “Converting Tables from MyISAM to InnoDB” . To make a partitioned table nonpartitioned, execute this statement: Any tables reported by the query must be dropped or renamed (use  RENAME TABLE ). This may also entail changes to applications that use the affected tables. 5. There must be no tables that have foreign key constraint names longer than 64 characters. Use this query to identify tables with constraint names that are too long: 3. Some keywords may be reserved in MySQL 8.0 that were not reserved previously. See Section 9.3, “Keywords and Reserved Words” . This can cause words previously used as identifiers to become illegal. To fix affected statements, use identifier quoting. See Section 9.2, “Schema Object Names” . 4. There must be no tables in the MySQL 5.7  mysql  system database that have the same name as a table used by the MySQL 8.0 data dictionary. To identify tables with those names, execute this query: ALTER TABLE  table_name  ENGINE = INNODB; ALTER TABLE  table_name  REMOVE PARTITIONING; SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE LOWER(TABLE_SCHEMA) = ’mysql’ and LOWER(TABLE_NAME) IN ( ’catalogs’, ’character_sets’, ’check_constraints’, ’collations’, ’column_statistics’, ’column_type_elements’, ’columns’, ’dd_properties’, ’events’, ’foreign_key_column_usage’, ’foreign_keys’, ’index_column_usage’, ’index_partitions’, ’index_stats’, ’indexes’, ’parameter_type_elements’, ’parameters’, ’resource_groups’, ’routines’, ’schemata’, ’st_spatial_reference_systems’, ’table_partition_values’, ’table_partitions’, ’table_stats’, ’tables’, ’tablespace_files’, ’tablespaces’, ’triggers’, ’view_routine_usage’, ’view_table_usage’ ); SELECT TABLE_SCHEMA, TABLE_NAME 284