修复./mysql/proc
mysql數(shù)據(jù)庫只能建不能刪的錯誤提示及處理方法:
mysql> drop database testmysqldatabase;
ERROR 145 (HY000): Table './mysql/proc' is marked as crashed and should be repaired
處理方法:直接在mysql數(shù)據(jù)庫里面使用root帳號登錄后,進行修復(fù):
mysql> repair table mysql.proc;
+------------+--------+----------+----------+
| Table ? ? ?| Op ? ? | Msg_type | Msg_text |
+------------+--------+----------+----------+
| mysql.proc | repair | status ? | OK ? ? ? |
+------------+--------+----------+----------+
1 row in set (0.05 sec)
mysql> drop database testmysqldatabase;
Query OK, 0 rows affected (0.02 sec)
轉(zhuǎn)載于:https://blog.51cto.com/ting2junshui/1739731
創(chuàng)作挑戰(zhàn)賽新人創(chuàng)作獎勵來咯,堅持創(chuàng)作打卡瓜分現(xiàn)金大獎總結(jié)
以上是生活随笔為你收集整理的修复./mysql/proc的全部內(nèi)容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: LL-verilog语法-generat
- 下一篇: Ubuntu18.04安装VCS、Ver