mysql 修复表

xiaoxiao2021-02-28  34

查看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: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;

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

| Table                 | Op     | Msg_type | Msg_text |

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

| gdwhtnew.wht_arccache | repair | status   | OK       |

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

1 row in set (0.00 sec)

转载请注明原文地址: https://www.6miu.com/read-1950334.html

最新回复(0)