A schema mismatch in a MySQL 8.0 instance between the
.frmfile of a table and the
InnoDBdata dictionary can cause an upgrade to MySQL 8.1 to fail. Such mismatches may be due to
.frmfile corruption. To address this issue, dump and restore affected tables before attempting the upgrade again.
If problems occur, such as that the new mysqld server does not start, verify that you do not have an old
my.cnffile from your previous installation. You can check this with the
--print-defaultsoption (for example, mysqld --print-defaults). If this command displays anything other than the program name, you have an active
my.cnffile that affects server or client operation.
If, after an upgrade, you experience problems with compiled client programs, such as
Commands out of syncor unexpected core dumps, you probably have used old header or library files when compiling your programs. In this case, check the date for your
libmysqlclient.alibrary to verify that they are from the new MySQL distribution. If not, recompile your programs with the new headers and libraries. Recompilation might also be necessary for programs compiled against the shared client library if the library major version number has changed (for example, from
If you have created a loadable function with a given name and upgrade MySQL to a version that implements a new built-in function with the same name, the loadable function becomes inaccessible. To correct this, use
DROP FUNCTIONto drop the loadable function, and then use
CREATE FUNCTIONto re-create the loadable function with a different nonconflicting name. The same is true if the new version of MySQL implements a built-in function with the same name as an existing stored function. See Section 9.2.5, “Function Name Parsing and Resolution”, for the rules describing how the server interprets references to different kinds of functions.
If upgrade to MySQL 8.1 fails due to any of the issues outlined in Section 2.10.5, “Preparing Your Installation for Upgrade”, the server reverts all changes to the data directory. In this case, remove all redo log files and restart the MySQL 8.0 server on the existing data directory to address the errors. The redo log files (
ib_logfile*) reside in the MySQL data directory by default. After the errors are fixed, perform a slow shutdown (by setting
innodb_fast_shutdown=0) before attempting the upgrade again.