今天打开blog一看数据库又坏掉了:
到论坛问了一下,原来是一个数据表坏掉了,然而phpmyadmin又进不了,我想用sql语句试试吧.baidu了一下,找到了:
点确认,哈哈成功了.Blog恢复正常!
引用
Bo-Blog Database System Tips: MySQL Query Error
Time: 2006-10-6 3:14am
Script:
SQL: SELECT * FROM `***blogs` WHERE `property`<>'3' ORDER BY `sticky`DESC, `pubtime` DESC LIMIT 0, 7
Error: Can't open file: '***blogs.MYD'. (errno: 145)
Errno.: 1016
Time: 2006-10-6 3:14am
Script:
SQL: SELECT * FROM `***blogs` WHERE `property`<>'3' ORDER BY `sticky`DESC, `pubtime` DESC LIMIT 0, 7
Error: Can't open file: '***blogs.MYD'. (errno: 145)
Errno.: 1016
到论坛问了一下,原来是一个数据表坏掉了,然而phpmyadmin又进不了,我想用sql语句试试吧.baidu了一下,找到了:
REPAIR TABLE boblog_blogs
点确认,哈哈成功了.Blog恢复正常!




