mysql 修复表

来源：互联网发布：淘宝客怎么拿优惠券编辑：程序博客网时间：2024/06/02 01:59

查看log发现mysql有一个表有错误

# tail /var/log/mysqld.log

151214 15:04:25 [ERROR] Got error 134 when reading table './gdwhtnew/wht_arccache'

151214 15:04:38 [ERROR] Got error 134 when reading table './gdwhtnew/wht_arccache'

151214 15:04:39 [ERROR] Got error 134 when reading table './gdwhtnew/wht_arccache'

151214 15:04:45 [ERROR] Got error 134 when reading table './gdwhtnew/wht_arccache'

151214 15:04:46 [ERROR] Got error 134 when reading table './gdwhtnew/wht_arccache'

151214 15:05:25 [ERROR] Got error 134 when reading table './gdwhtnew/wht_arccache'

151214 15:05:34 [ERROR] Got error 134 when reading table './gdwhtnew/wht_arccache'

151214 15:05:37 [ERROR] Got error 134 when reading table './gdwhtnew/wht_arccache'

151214 15:06:17 [ERROR] Got error 134 when reading table './gdwhtnew/wht_arccache'

在mysql命令行进行修复

mysql> use gdwhtnew;

No connection. Trying to reconnect...

Connection id: 359631

Current database: *** NONE ***

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> repair table wht_arccache;

+-----------------------+--------+----------+----------+

+-----------------------+--------+----------+----------+

+-----------------------+--------+----------+----------+

1 row in set (0.00 sec)

阅读全文

0 0