MySQL 8 Administrator???s Guide

Upgrading prerequisites for MySQL 5.7

Before starting up-gradation, perform the following checks to avoid failure during later stages:

1. Execute the following command to check there is no absolute datatypes or function:

        mysqlcheck -u root -p--all-databases--check-upgrade

2. Check for native partitioning support, using the following command:

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

This command will list tables that use the storage engine which doesn't support native partitioning. After executing the preceding query, if any table is found then remove the partitioning on the table and change the storage engine, as shown in the following ...