关于Warning: mysqli_query(): (HY000/1194): Table ‘wp_tengwaoptions’ is marked as crashed and should be repaired in /www/wwwroot/www.tengwa.net/wp-includes/wp-db.php on line 2056数据表格损坏修复
![](https://cdn.tengwa.net/%E5%85%B3%E4%BA%8EWarning%3A%20mysqli_query%28%29%3A%20%28HY000/1194%29%3A%20Table%20%27wp_tengwaoptions%27%20is%20marked%20as%20crashed%20and%20should%20be%20repaired%20in%20/www/wwwroot/www.tengwa.net/wp-includes/wp-db.php%20on%20line%202056%E6%95%B0%E6%8D%AE%E8%A1%A8%E6%A0%BC%E6%8D%9F%E5%9D%8F%E4%BF%AE%E5%A4%8D%E5%BE%AE%E4%BF%A1%E5%9B%BE%E7%89%87_20211203120432.jpg)
今天打开网站打不开,网页显示一串英文,大概内容是Error establishing a database connection翻译过来就是建立数据库链接时出错。
第一的解决办法就是重启服务器,重启服务器后网站恢复了,但是打开网站后台显示的一串英文Warning: mysqli_query(): (HY000/1194): Table ‘wp_tengwaoptions’ is marked as crashed and should be repaired in /www/wwwroot/www.tengwa.net/wp-includes/wp-db.php on line 2056
翻译成中文
警告:mysqli_query():(HY000/1194):表“wp_tengwaoptions”标记为崩溃,应在第2056行的/www/wwwroot/www.tengwa.net/wp-includes/wp-db.php中修复
原因找到了,就是有数据库表格崩溃了,修复下就好了,如果你使用的时宝塔LINUX面板的话,参考我的结局方式。
1数据库
2工具
3找到崩溃的数据表,直接点击修复即可
![](https://cdn.tengwa.net/%E5%85%B3%E4%BA%8EWarning%3A%20mysqli_query%28%29%3A%20%28HY000/1194%29%3A%20Table%20%27wp_tengwaoptions%27%20is%20marked%20as%20crashed%20and%20should%20be%20repaired%20in%20/www/wwwroot/www.tengwa.net/wp-includes/wp-db.php%20on%20line%202056%E6%95%B0%E6%8D%AE%E8%A1%A8%E6%A0%BC%E6%8D%9F%E5%9D%8F%E4%BF%AE%E5%A4%8D%E5%BE%AE%E4%BF%A1%E6%88%AA%E5%9B%BE_20211203121606.png)
修复完成就可以了,如果还有显示的话,装有缓存插件的请更新。
还有就是使用数据库工具修复,比如MYISAMCHK工具。
一个好的习惯就是定时备份。
不错,必须顶一下!
这个是网站错误了嘛
网站打开错误的修复