升级 MySQL 时出现“无效的 utf8 字符串”错误

升级 MySQL 时出现“无效的 utf8 字符串”错误

我的本地 MacBook Pro 上有一些 InnoDB 数据库。通过brew upgradeMySQL 守护程序升级 MySQL 后现在无法启动。

我已经通过重命名文件系统中的相应表来解决了新的不区分大小写模式的问题。

但仍然存在错误Invalid utf8 character string,我不知道如何修复。

2019-11-29T10:55:32.147554Z 0 [System] [MY-010116] [Server] /usr/local/Cellar/mysql/8.0.18_1/bin/mysqld (mysqld 8.0.18) starting as process 36384
2019-11-29T10:55:32.152566Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
2019-11-29T10:55:32.166564Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2019-11-29T10:55:36.248838Z 2 [ERROR] [MY-013140] [Server] Invalid utf8 character string: '8AAEAB'
2019-11-29T10:55:36.253228Z 2 [ERROR] [MY-013140] [Server] Invalid utf8 character string: '84A5A9'
2019-11-29T10:55:36.254541Z 2 [ERROR] [MY-013140] [Server] Invalid utf8 character string: '92A8AF'
2019-11-29T10:55:36.273197Z 2 [ERROR] [MY-013140] [Server] Invalid utf8 character string: '8CAEAB'
2019-11-29T10:55:38.424116Z 0 [ERROR] [MY-010022] [Server] Failed to Populate DD tables.
2019-11-29T10:55:38.424785Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-11-29T10:55:39.484843Z 0 [System] [MY-010910] [Server] /usr/local/Cellar/mysql/8.0.18_1/bin/mysqld: Shutdown complete (mysqld 8.0.18)  Homebrew.

我不知道这些字符在哪个表中。而且我找不到可以用这些 3 字节字符串编码的任何字符。

相关内容