【已完成】mysql 5.7.44 重启失败

为了能快速了解并处理您的问题，请提供以下基础信息：

面板、插件版本：

系统版本：

问题描述：mysql 5.7.44 重启失败

相关截图（日志、错误）：

启动报错：Starting MySQL.. ERROR! The server quit without updating PID file (/www/server/data/ecm-a6bc.novalocal.pid).

使用下面命令获取MySQL的错误日志信息：

1. cat /www/server/data/*.err | grep -i -C 10 ERROR

复制代码

谢花郎 发表于 2024-1-26 11:11
使用下面命令获取MySQL的错误日志信息：

2024-01-25 02:30:22 2011 [Warning] InnoDB: Cannot open table crmeb/eb_express from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2024-01-25 02:30:22 2011 [Warning] InnoDB: Cannot open table crmeb/eb_express from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2024-01-25 02:30:22 2011 [Warning] InnoDB: Cannot open table crmeb/eb_live_anchor from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2024-01-25 02:30:22 2011 [Warning] InnoDB: Cannot open table crmeb/eb_live_anchor from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2024-01-25 02:30:22 2011 [Warning] InnoDB: Cannot open table crmeb/eb_live_goods from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2024-01-25 02:30:22 2011 [Warning] InnoDB: Cannot open table crmeb/eb_live_goods from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2024-01-25 02:30:22 2011 [Warning] InnoDB: Cannot open table crmeb/eb_live_room from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2024-01-25 02:30:22 2011 [Warning] InnoDB: Cannot open table crmeb/eb_live_room from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2024-01-25 02:30:22 2011 [Warning] InnoDB: Cannot open table crmeb/eb_live_room_goods from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2024-01-25 02:30:22 2011 [Warning] InnoDB: Cannot open table crmeb/eb_live_room_goods from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.

谢花郎 发表于 2024-1-26 11:11
使用下面命令获取MySQL的错误日志信息：

启动报错：Starting MySQL.. ERROR! The server quit without updating PID file (/www/server/data/ecm-a6bc.novalocal.pid).

宝塔用户_ofzrjv 发表于 2024-1-26 11:22
2024-01-25 02:30:22 2011 [Warning] InnoDB: Cannot open table crmeb/eb_express from the internal da ...

找数据恢复机构处理，数据库表异常了。