客户将MySQL 5.7升级至8.0，升级后MySQL 8.0无法启动报数据字典不一致Data Dictionary initialization failed。

客户名称: 市政相关

数据类型: MySQL 8.0

数据库大小: 6GB

故障检测: MySQL 8.0无法启动，报错如下：

2023-10-10T12:32:25.427710Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-10-10T12:32:25.474505Z 1 [ERROR] [MY-012209] [InnoDB] Multiple files found for the same tablespace ID:
2023-10-10T12:32:25.474506Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 27 = ['sakila\staff.ibd', 'xlife_city_brain\a*****_trend.ibd']
2023-10-10T12:32:25.474507Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 29 = ['world\city.ibd', 'xlife_city_brain\bi*****_total.ibd']
2023-10-10T12:32:25.474508Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 30 = ['world\country.ibd', 'xlife_city_brain\bi*****_usage.ibd']
2023-10-10T12:32:25.474509Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Failed, retry may succeed.
2023-10-10T12:32:25.474510Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-10-10T12:32:25.474511Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

使用公司研发的MySQL数据库恢复工具从MySQL 8.0的ibd数据文件恢复数据。

修复结果: 数据恢复率达100% 客户非常满意。将恢复出来的业务表的数据导入客户生产环境可以直接问题。