全球主机交流论坛

标题: wordpress数据库修复问题，无法修复！！！ [打印本页]

---

作者: yxq4319    时间: 2010-7-6 11:42
标题: wordpress数据库修复问题，无法修复！！！
吐血了，果然数据库有问题，但是貌似用WP2.9自带的修复功能还无法将它制服啊！哎，各位大大，有高招没？

The wp_users table is okay.
The wp_users table is already optimized.

The wp_usermeta table is okay.
The wp_usermeta table is already optimized.

The wp_posts table is not okay. It is reporting the following error: 2 clients are using or haven't closed the table properly. WordPress will attempt to repair this table…
Failed to repair the wp_posts table. Error: 2 clients are using or haven't closed the table properly


The wp_comments table is not okay. It is reporting the following error: 1 client is using or hasn't closed the table properly. WordPress will attempt to repair this table…
Failed to repair the wp_comments table. Error: 1 client is using or hasn't closed the table properly


The wp_links table is okay.

The wp_options table is not okay. It is reporting the following error: 5 clients are using or haven't closed the table properly. WordPress will attempt to repair this table…
Failed to repair the wp_options table. Error: 5 clients are using or haven't closed the table properly


The wp_postmeta table is not okay. It is reporting the following error: 2 clients are using or haven't closed the table properly. WordPress will attempt to repair this table…
Failed to repair the wp_postmeta table. Error: 2 clients are using or haven't closed the table properly


The wp_terms table is not okay. It is reporting the following error: 1 client is using or hasn't closed the table properly. WordPress will attempt to repair this table…
Failed to repair the wp_terms table. Error: 1 client is using or hasn't closed the table properly


The wp_term_taxonomy table is not okay. It is reporting the following error: 2 clients are using or haven't closed the table properly. WordPress will attempt to repair this table…
Failed to repair the wp_term_taxonomy table. Error: 2 clients are using or haven't closed the table properly


The wp_term_relationships table is not okay. It is reporting the following error: 2 clients are using or haven't closed the table properly. WordPress will attempt to repair this table…
Failed to repair the wp_term_relationships table. Error: 2 clients are using or haven't closed the table properly


The wp_commentmeta table is okay.

[ 本帖最后由 yxq4319 于 2010-7-6 12:35 编辑 ]

---

作者: cnx    时间: 2010-7-6 11:51
不懂哈，帮你顶。

---

作者: netroby    时间: 2010-7-6 11:54
重启mysql数据库看看，似乎有表占用冲突？

---

作者: bzdk    时间: 2010-7-6 11:57
考虑使用repair语句和myisamcheck来做表修复吧

---

作者: gdtv    时间: 2010-7-6 12:03
3、4楼已经回答了

---

作者: cuxian    时间: 2010-7-6 12:03
重启下

---

作者: yxq4319    时间: 2010-7-6 12:06

原帖由 netroby 于 2010-7-6 11:54 发表
重启mysql数据库看看，似乎有表占用冲突？

哇哇哇，果然是高手，我重启mysql之后，马上修复，果然全部OK了

---

作者: yxq4319    时间: 2010-7-6 12:07

原帖由 bzdk 于 2010-7-6 11:57 发表
考虑使用repair语句和myisamcheck来做表修复吧

程序方面我不懂，不过用的是WP2.9的修复功能，用的是这一句，应该是你说的那个repair语句吧？

define('WP_ALLOW_REPAIR', true);

---

作者: gdtv    时间: 2010-7-6 12:11
先进去phpmyadmin里修改一下吧

---

作者: yxq4319    时间: 2010-7-6 12:19

原帖由 gdtv 于 2010-7-6 12:11 发表
先进去phpmyadmin里修改一下吧

在里面修改什么，怎么修改啊？

---

作者: tanghaiwei    时间: 2010-7-6 12:25
  牛人

---

作者: gdtv    时间: 2010-7-6 14:34

原帖由 yxq4319 于 2010-7-6 12:19 发表

在里面修改什么，怎么修改啊？

选中所有表-->修复表

---

欢迎光临 全球主机交流论坛 (https://loc.888543.xyz/)

Powered by Discuz! X3.4