MySQL无法启动求助：InnoDB日志序列号异常，需保留重要数据

问题详情 #

• 已尝试网上提及的多种解决方法，也自行尝试修复，但仍不清楚下一步操作方向
• 数据库存储有重要数据，绝对不能进行重装操作
• 已尝试更新配置文件、无密码启动等操作，问题仍未解决

错误日志信息 #

2022-12-31  0:32:28 2 [ERROR] InnoDB: Page [page id: space=24, page number=1] log sequence number 300669 is in the future! Current system log sequence number 300459.
2022-12-31  0:32:28 2 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to htts://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2022-12-31  0:32:28 0 [Note] InnoDB: 10.4.27 started; log sequence number 300450; transaction id 214
2022-12-31  0:32:28 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-12-31  0:32:28 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-12-31  0:32:28 0 [Note] Server socket created on IP: '::'.

内容的提问来源于stack exchange，提问作者Nico Proyer