MySQL 表顺坏的修复: Table is marked as crashed and should be repaired

今日上午10点20,网站不能访问后,有2个数据库均出现了某个表顺坏,

user warning: Table 'cache_filter' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid =' in /includes/cache.inc on line 26

user warning: Table /cache_menu' is marked as crashed and should be repaired query: UPDATE cache_menu SET data = 'links:navigation:tree-data:x', created = x, expire = 0, headers = '', serialized = 0 WHERE cid = 'links:navigation:page-cid:node:1' in /htdocs/includes/cache.inc on line 109.

进phpmyadmin修复:
REPAIR TABLE `cache_filter`

REPAIR TABLE `cache_menu`


之后终于恢复了正常.

Table Op Msg_type Msg_text
cache_filter repair status OK
cache_menu repair status OK

发表新评论

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <i> <b> <a> <em> <strong> <small> <big> <cite> <code> <img> <ul> <ol> <li> <dl> <dt> <dd> <tbody> <th> <table> <caption> <colgroup> <col> <thead> <tfoot> <br> <tr> <table> <td> <span> <p> <h1> <h1> <h1> <h2> <h3> <h4> <h5> <hr> <!--> <ins> <del> <kbd> <quote> <blockquote>
  • Lines and paragraphs break automatically.

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
3 + 2 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.