【已完成】服务器里的网站数据库都没了

服务器里的数据库文件都没了，打不开数据路，也登录不了网站后台。但看日志，我也没操作什么。麻烦帮忙看下

进入phpmyadmin查看 是数据库里面所有表都被删除了？

您好，您在phpmyadmin看一下是否还有数据，另外截图看一下面板日志

堡塔运维向樛木 发表于 2022-11-29 09:26
您好，您在phpmyadmin看一下是否还有数据，另外截图看一下面板日志

只有表名，表结构跟数据都没了

向樛木多少斤了 发表于 2022-11-29 09:18
进入phpmyadmin查看 是数据库里面所有表都被删除了？

是的，只有表名，数据库结构数据都没有了

宝塔用户_lhrwlo 发表于 2022-11-29 09:39
是的，只有表名，数据库结构数据都没有了

服务器命令行执行以下命令查看MySQL错误日志

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

复制代码

堡塔运维向樛木 发表于 2022-11-29 09:51
服务器命令行执行以下命令查看MySQL错误日志

应该是这个时间段后数据库就没了

2022-11-28T00:25:54.087662Z 7062121 [Note] Got an error reading communication packets
2022-11-28T00:57:52.691674Z 7063816 [Warning] Hostname 'zg-1031a-82.stretchoid.com' does not resolve to '192.241.192.66'.
2022-11-28T00:57:52.691701Z 7063816 [Note] Hostname 'zg-1031a-82.stretchoid.com' has the following IP addresses:
2022-11-28T00:57:52.691705Z 7063816 [Note]  - 127.0.0.1
2022-11-28T00:57:52.827891Z 7063816 [Note] Got an error reading communication packets
2022-11-28T00:59:25.828803Z 7063898 [Warning] IP address '34.78.6.216' has been resolved to the host name '216.6.78.34.bc.googleusercontent.com', which resembles IPv4-address itself.
2022-11-28T00:59:26.076758Z 7063898 [Note] Got an error reading communication packets
2022-11-28T00:59:26.459284Z 7063900 [Warning] IP address '35.195.93.98' has been resolved to the host name '98.93.195.35.bc.googleusercontent.com', which resembles IPv4-address itself.
2022-11-28T00:59:27.204369Z 7063900 [Note] Access denied for user 'root'@'35.195.93.98' (using password: NO)
2022-11-28T01:04:52.956820Z 7064193 [Warning] IP address '167.94.145.59' could not be resolved: Name or service not known
2022-11-28T01:04:53.626121Z 7064193 [Note] Got an error reading communication packets
2022-11-28T01:19:02.439642Z 7064940 [Warning] IP address '183.129.255.27' could not be resolved: Name or service not known
2022-11-28T01:19:02.450734Z 7064940 [Note] Got an error reading communication packets
2022-11-28T01:19:02.465948Z 7064942 [Note] Got an error reading communication packets
2022-11-28T01:19:02.478251Z 7064943 [Note] Got an error reading communication packets
2022-11-28T01:19:02.507645Z 7064945 [Note] Got an error reading communication packets
2022-11-28T01:19:02.519911Z 7064946 [Note] Got an error reading communication packets
2022-11-28T04:03:58.425466Z 7073687 [Note] Got an error reading communication packets
2022-11-28T05:01:03.952544Z 7073821 [Note] Unknown database 'xinqing'

堡塔运维向樛木 发表于 2022-11-29 09:51
服务器命令行执行以下命令查看MySQL错误日志

要怎么处理啊，急急急

您好，请问您的问题解决了吗？没有解决的话麻烦重新发帖以便处理。