宝塔用户_ofzrjv 发表于 2024-1-26 10:53:08

【已完成】mysql 5.7.44 重启失败

为了能快速了解并处理您的问题，请提供以下基础信息：面板、插件版本：
系统版本：
问题描述：mysql 5.7.44 重启失败
相关截图（日志、错误）：

宝塔用户_ofzrjv 发表于 2024-1-26 10:55:01

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

谢花郎 发表于 2024-1-26 11:11:30

使用下面命令获取MySQL的错误日志信息：
cat /www/server/data/*.err | grep -i -C 10 ERROR

宝塔用户_ofzrjv 发表于 2024-1-26 11:22:03

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

2024-01-25 02:30:22 2011 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 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 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 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 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 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 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 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 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 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.

宝塔用户_ofzrjv 发表于 2024-1-26 11:22:45

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

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

谢花郎 发表于 2024-1-26 11:28:14

宝塔用户_ofzrjv 发表于 2024-1-26 11:22
2024-01-25 02:30:22 2011 InnoDB: Cannot open table crmeb/eb_express from the internal da ...
找数据恢复机构处理，数据库表异常了。
页: [1]
查看完整版本: 【已完成】mysql 5.7.44 重启失败