ERROR 145 (HY000): Table '$ table' is marked... solve the Problem of opening the system today and troubleshoot the ERROR: www.2cto.com ERROR 145 (HY000): Table '. /cmxt/cm_user_pref 'is marked as crashed and shoshould be rewritable red solution: (this solution is successfully repaired) mysql> repair table cmxt. cm_user_pref; + ------------------- + -------- + ---------- + | Table | Op | Msg_type | Msg_text | + ------------------- + -------- + ---------- + | cmxt. cm_user_pref | repair | status | OK | + --------------------- + -------- + ---------- + google posted a top post. The solution is as follows: Directory 2 of the inventory file. /myisamchk-c-r database table MYI file path 3 (for example,/home/mysql/var/crawlerfeedsky/aaaa. MYI) 4. If not, force-f to fix it.
If you try this solution, but it does not work, the following error will be reported: myisamchk: error: 20 when opening MyISAM-table '../mysql/cmxt/cm_user_pref' is not very understandable. But the above repair table method is OK.