【已完成】服务器里的网站数据库都没了
本帖最后由 堡塔运维香菜卷 于 2023-3-21 12:27 编辑服务器里的数据库文件都没了，打不开数据路，也登录不了网站后台。但看日志，我也没操作什么。麻烦帮忙看下
进入phpmyadmin查看 是数据库里面所有表都被删除了？
您好，您在phpmyadmin看一下是否还有数据，另外截图看一下面板日志 堡塔运维向樛木 发表于 2022-11-29 09:26
您好，您在phpmyadmin看一下是否还有数据，另外截图看一下面板日志
只有表名，表结构跟数据都没了https://xqps.vip/mb.jpg 向樛木多少斤了 发表于 2022-11-29 09:18
进入phpmyadmin查看 是数据库里面所有表都被删除了？
是的，只有表名，数据库结构数据都没有了 宝塔用户_lhrwlo 发表于 2022-11-29 09:39
是的，只有表名，数据库结构数据都没有了
服务器命令行执行以下命令查看MySQL错误日志
cat /www/server/data/*.err|grep -i -C 10 error
堡塔运维向樛木 发表于 2022-11-29 09:51
服务器命令行执行以下命令查看MySQL错误日志
应该是这个时间段后数据库就没了
2022-11-28T00:25:54.087662Z 7062121 Got an error reading communication packets
2022-11-28T00:57:52.691674Z 7063816 Hostname 'zg-1031a-82.stretchoid.com' does not resolve to '192.241.192.66'.
2022-11-28T00:57:52.691701Z 7063816 Hostname 'zg-1031a-82.stretchoid.com' has the following IP addresses:
2022-11-28T00:57:52.691705Z 7063816 - 127.0.0.1
2022-11-28T00:57:52.827891Z 7063816 Got an error reading communication packets
2022-11-28T00:59:25.828803Z 7063898 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 Got an error reading communication packets
2022-11-28T00:59:26.459284Z 7063900 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 Access denied for user 'root'@'35.195.93.98' (using password: NO)
2022-11-28T01:04:52.956820Z 7064193 IP address '167.94.145.59' could not be resolved: Name or service not known
2022-11-28T01:04:53.626121Z 7064193 Got an error reading communication packets
2022-11-28T01:19:02.439642Z 7064940 IP address '183.129.255.27' could not be resolved: Name or service not known
2022-11-28T01:19:02.450734Z 7064940 Got an error reading communication packets
2022-11-28T01:19:02.465948Z 7064942 Got an error reading communication packets
2022-11-28T01:19:02.478251Z 7064943 Got an error reading communication packets
2022-11-28T01:19:02.507645Z 7064945 Got an error reading communication packets
2022-11-28T01:19:02.519911Z 7064946 Got an error reading communication packets
2022-11-28T04:03:58.425466Z 7073687 Got an error reading communication packets
2022-11-28T05:01:03.952544Z 7073821 Unknown database 'xinqing'
堡塔运维向樛木 发表于 2022-11-29 09:51
服务器命令行执行以下命令查看MySQL错误日志
要怎么处理啊，急急急 您好，请问您的问题解决了吗？没有解决的话麻烦重新发帖以便处理。
页:
[1]