我每周都会遇到 MySQL 意外关闭的情况,我必须彻底解决这个问题

我每周都会遇到 MySQL 意外关闭的情况,我必须彻底解决这个问题

当我打开 XAMPP 控制面板时v3.3.0然后单击启动 MySQL 按钮,结果出现错误。

错误日志。

Error: MySQL shutdown unexpectedly.
This may be due to a blocked port, missing dependencies, 
improper privileges, a crash, or a shutdown by another method.
Press the Logs button to view error logs and check
the Windows Event Viewer for more clues
If you need more help, copy and post this
entire log window on the forums

我试过法布里齐奥·巴伦西亚 回答问题得到了很好的解决,糟糕的是,我每周都会遇到这个错误,但这个解决方案不是最佳实践。我必须彻底解决这个问题。

Windows 事件查看器上的错误;

InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.

InnoDB: Page [page id: space=0, page number=2] log sequence number 1339427 is in the future! Current system log sequence number 300306.

相关内容