網路城邦
上一篇 回創作列表 下一篇   字體:
MySQL errno: 145 Can't open XXXX how to
2008/05/29 18:46:17瀏覽809|回應0|推薦1
解決的方式其實很簡單 ~ 登入到主機後,在 Shell 的環境上連進 MySQL,再下指令去修復它即可


[code lang="html"]
dns# ./mysql -u root -p
Enter password:
mysql> use phpbb
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Didn't find any fields in table 'phpbb_sessions'
Database changed
mysql> repair table phpbb_sessions;
+----------------------+--------+----------+------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+----------------------+--------+----------+------------------------------------------+
| phpbb.phpbb_sessions | repair | warning | Number of rows changed from 2357 to 2373 |
| phpbb.phpbb_sessions | repair | status | OK |
+----------------------+--------+----------+------------------------------------------+
2 rows in set (0.06 sec)
[/code]
嘿嘿,終於又回復正常囉

( 休閒生活網路生活 )
回應 推薦文章 列印 加入我的文摘
上一篇 回創作列表 下一篇

引用
引用網址:https://classic-blog.udn.com/article/trackback.jsp?uid=wordred0227&aid=1912240