whos_online' is marked asblam oni crashedd and should be repai...

来源：蜘蛛抓取(WebSpider) 时间：2011-06-29 09:06 标签： blam oni crashed
database（6）
1.遇到这个问题的时候就百度了一下，开始没找到答案，最后看了几个命令就尝试了一下，居然成功了。
2.首先进入mysql命令台：mysql -u root -p 回车& 输入密码
3.进入到表所在的数据库，check table newabout用来检查出现问题的表的状态，出现错误就正常
4.然后用repair table newabout
5.再用check table newabout
* 以上用户言论只代表其个人观点，不代表CSDN网站的观点或立场
访问：337189次
积分：3615
积分：3615
排名：第5024名
原创：41篇
转载：144篇
评论：48条
(2)(1)(1)(1)(4)(1)(3)(11)(1)(7)(5)(20)(5)(4)(6)(10)(4)(3)(2)(3)(1)(1)(11)(4)(3)(3)(2)(1)(1)(3)(4)(9)(2)(4)(5)(1)(17)(5)(14)MySQL: table is marked as crashed - Server Fault
to customize your list.
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.
Here's how it works:
Anybody can ask a question
Anybody can answer
The best answers are voted up and rise to the top
After a disk full issue one of the MySQL DBs on the server is coming up with the following error when I try to back it up:
[root@mybox ~]# mysqldump -p --result-file=/tmp/dbbackup.sql --database myDBname
Enter password:
mysqldump: Got error: 145: Table './myDBname/myTable1' is marked as crashed and should be repaired when using LOCK TABLES
A bit of investigation shows two tables have this issue.
What needs to be done to fix up the damaged tables?
2,487145188
To check the tables:
CHECK TABLE mytable1
To repair the table:
REPAIR TABLE mytable1
2,487145188
cd /var/lib/mysql/dbname
myisamchk --silent --force *.MYI
cliffsupport
Your Answer
Sign up or
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Post as a guest
By posting your answer, you agree to the
Not the answer you're looking for?
Browse other questions tagged
Server Fault works best with JavaScript enabled您好，欢迎来到shopex插件之家-提供专业的shopex二次开发,分销王二次开发,shopex插件,分销王插件开发服务！！
ShopEx 4.85网店系统由近百人资深研发团队，历时7年精心打造，以...
ShopEx登录后台提示“非法授权”后跳转到登录页的解决办法：...
技术/服务咨询
ShopEx后台table xxx is marked as crashed and should be repaired的解决办法
时间: 19:53 来源:MyShopEx插件站 作者:本站原创 点击:
使用ShopEx网店程序的朋友，可能会遇到后台页面报错的情况，如下：Warning:
s.op_id,s.sess_data,o.name,o.username,o.super,o.status,o.disabled,o.config
FROM sdb_op_sessions s
left join sdb_operators o
on o.op_id = s.op_id
WHERE s.sess_id = 'b5e56ebe83d43b05d5cbee006ca00a0d'
LIMIT 0, 1:Table '.\sqhuang518\sdb_op_sessions' is marked as crashed and
should be repaired in D:\wwwroot\core\include_v5\AloneDB.phpon line 79Warning:
SELECT * FROM sdb_op_sessions WHERE
sess_id='b5e56ebe83d43b05d5cbee006ca00a0d':Table
'.\sqhuang518\sdb_op_sessions' is marked as crashed and should be
repaired in D:\wwwroot\core\include_v5\AloneDB.phpon line 79Fatal error:
GetUpdateSQL:
in D:\wwwroot\core\include_v5\core\db.tools.phpon line 4修复方法如下：1、命令行进行修复myisamchk&-f&'C:\xxx\MySQL\MySQL&Server&5.1\data\mysql\sdb_op_sessions.MYI'或者myisamchk&-c&-r&'C:\xxx\MySQL\MySQL&Server&5.1\data\mysql\sdb_op_sessions.MYI'注意要修改自己的路径，-f表示强制修复。2、使用phpmyadmin进行修复进入管理mysql的phpmyadmin，&在左则选中自己的数据库，在右则勾选中错误信息中的那个pre_ucenter_members表，滚动屏幕到下面，有个下拉菜单(With&selected:)，选择”Repair&table”。这样就可以进行修复了！3、使用其他工具，如：Navicat&for&MySQL使用第三方的数据库修复工具进行修改数据库表，具体方法请参考相关软件的使用说明。&
(责任编辑：admin)mysql错误提示1194 - Tdb_role_attr_p; is marked as crashed and should be repaired 怎修复啊？_百度知道
mysql错误提示1194 - Tdb_role_attr_p; is marked as crashed and should be repaired 怎修复啊？
我有更好的答案
看你的表是什么引擎了，Myisam用repair table 表名
其他类似问题
为您推荐：
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁

我要回帖

更多关于 blam oni crashed 的文章

 

随机推荐