mysql 8.0 database recovery mysql database 8.0 failed to start recovery mysql 8.0.26 database corruption recovery
Customer name Confidential
Data type mysql 8.0.26
data capacity 3 GB
Failure type The server disk is full, causing the mysql database to be corrupted and cannot be started, and the forced recovery parameter is invalid, seeking recovery.
alter table user import tablespace;
ERROR 1808 (HY000): Schema mismatch (Clustered index validation failed. Because the .cfg file is missing, table definition of the IBD file could be different. Or the data file itself is already corrupted.)
mysql> show warnings;
+---------+------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Level | Code | Message |
+---------+------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Warning | 1810 | InnoDB: IO Read error: (2, No such file or directory) Error opening './baiwuji_com/user.cfg', will attempt to import without schema verification |
| Error | 1808 | Schema mismatch (Clustered index validation failed. Because the .cfg file is missing, table definition of the IBD file could be different. Or the data file itself is already corrupted.) |
| Error | 1034 | Incorrect key file for table 'fn_user'; try to repair it |
Repair results Use the excellent mysql database recovery tool to complete the recovery from the IBD file parsing data, and the recovery rate is 100%.
Takes 3 hours
of man-hours
Shenzhen Excellent Data Rescue Center kindly reminds: important data must be backed up frequently, and when encountering data loss, data corruption and other problems, you should contact professionals as soon
as possible. For all kinds of mainstream databases, we can do the lowest level of data recovery and data repair, for the database
For certain failures, we guarantee that the database is restored 100% as-is, no matter how large the database is.
Comments