24小时咨询热线:13811580958(微信)
7 x 24 在线支持!国内领先的专业数据库恢复公司!

客户案例

MySQL升级导致数据字典不一致MySQL无法启动 MySQL数据库恢复
发布时间:2023-10-11

客户将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% 客户非常满意。将恢复出来的业务表的数据导入客户生产环境可以直接问题。

-----------------------------------------------------------------------------------------------------------
提供7*24专业SQL Server数据库修复,MySQL数据库修复,Sybase数据库远程及现场技术支持,Sybase ASE及Sybase SQL Anywhere数据库修复服务,Oracle数据库修复,PostgreSQL数据库恢复。
电话:13811580958(微信),QQ:289965371
We supply technical support for Sybase ASE and Sybase SQL Anywhere, also have many years of experience in recovering data from damanged Sybase devices. Contact us by
Phone: +86 13811580958
Wechat: 13811580958
Email: 289965371@qq.com
扫描雨翰数据恢复官方微信获取专业数据库恢复服务

咨询热线:

13811580958

返回顶部
在线咨询