xammp启动MySQL时候报错,查询日志报如下信息:

测试的小白 2022-09-24 19:19:37

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
 

有没有哪位小伙伴好的解决办法,在线求解~~~

...全文
37 5 打赏 收藏 举报
写回复
5 条回复
切换为时间正序
请发表友善的回复…
发表回复
惜分飞 10-27
  • 打赏
  • 举报
回复

从这里看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不支持,换个就行

  • 举报
回复
@花花的小脑瓜 存储引擎怎么更换呢?
  • 举报
回复
@测试的小白 1.找到my-small.ini文件,将my-small.ini另存为my.ini,在[mysqld]最后添加为上default-storage-engine=MyISAM,重启服务,数据库默认的引擎修改为MyISAM 2.建表时指定:create table mytbl( id int primary key, name varchar(50)) type=MyISAM;
  • 举报
回复
@测试的小白 两个选一个就行
相关推荐
发帖
MySQL

5.6w+

社区成员

MySQL相关内容讨论专区
社区管理员
  • MySQL
加入社区
帖子事件
创建了帖子
2022-09-24 19:19
社区公告
暂无公告