5.6w+
社区成员
InnoDB: using atomic writes.
2022-09-24 19:12:09 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-09-24 19:12:09 0 [Note] InnoDB: Uses event mutexes
2022-09-24 19:12:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-24 19:12:09 0 [Note] InnoDB: Number of pools: 1
2022-09-24 19:12:09 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-24 19:12:09 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-09-24 19:12:09 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-24 19:12:09 0 [Note] InnoDB: Header page consists of zero bytes in datafile: D:\Xampp\mysql\data\ibdata1, Space ID:0, Flags: 0
2022-09-24 19:12:09 0 [ERROR] InnoDB: Corrupted page [page id: space=0, page number=0] of datafile 'D:\Xampp\mysql\data\ibdata1' could not be found in the doublewrite buffer.
2022-09-24 19:12:09 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2022-09-24 19:12:09 0 [Note] InnoDB: Starting shutdown...
2022-09-24 19:12:09 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-09-24 19:12:09 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-09-24 19:12:09 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-24 19:12:09 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-09-24 19:12:09 0 [ERROR] Aborting
有没有哪位小伙伴好的解决办法,在线求解~~~
从这里看InnoDB: Header page consists of zero bytes in datafile: D:\Xampp\mysql\data\ibdata1, Space ID:0, Flags: 0
mysql ibdata文件异常了,这种情况下,就算初始化了ibdata,也无法恢复ibd或者以前的ibdata里面的数据,这种情况下,需要做mysql 非常规的恢复,你可以参考:
frm和ibd文件数据库恢复
InnoDB' init function returned error. Plugin 'InnoDB' registration as a STORAGE ENGINE failed. Unknown/unsupported storage engine: InnoDB从错误提示来看是选择的数据库存储引擎InnoDB不支持,换个就行