wordpress数据库修复问题，无法修复！！！

yxq4319

吐血了，果然数据库有问题，但是貌似用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

不懂哈，帮你顶。

netroby

重启mysql数据库看看，似乎有表占用冲突？

bzdk

考虑使用repair语句和myisamcheck来做表修复吧

gdtv

3、4楼已经回答了

cuxian

重启下

yxq4319

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

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

yxq4319

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

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

define('WP_ALLOW_REPAIR', true);

gdtv

先进去phpmyadmin里修改一下吧

yxq4319

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

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