`
aqbjzxl
  • 浏览: 19986 次
  • 性别: Icon_minigender_1
  • 来自: 吉安
文章分类
社区版块
存档分类
最新评论

利用TMD表“is marked as crashed and last (automatic?)

阅读更多
   今天进网站的时候突然打不开,进数据库一看,好几个表出现利用TMD表“is marked as crashed and last (automatic?) 错误,马上去网上查看资料,查看的资料说把TMD文件改成MDY文件,再用myisamchk -r *.MYI修复,修复了好几次,不是不行。根据MYSQL提示修复,表是修复了。网站也可以打开了。但是当我再次用myisamchk -r 修复表的时候,又出现TMD文件了。又变回修复前了。网站也打不开了。
  因修复之前整个数据文件进行了备份,就想,把数据库文件放在其它的盘用myisamchk -r 修复所以表,这次没有出错,我知道没问题了,再把MYSQL配置文件指向新的数据,启动MYSQL,打开网站一切正常了。
   想不到这次的正直问题是硬盘有问题。
   弄了几个小时,原来就这问题。
分享到:
评论
1 楼 hyy_php 2013-06-05  
请问楼主,问题原因是什么?
我的数据库频繁出现此问题,修复之后还会坏

相关推荐

    Mysql中Table ‘XXX’ is marked as crashed and last (automatic?)问题解决方法

    主要介绍了Mysql中Table ‘XXX’ is marked as crashed and last (automatic?)问题解决方法,需要的朋友可以参考下

    MySQL error code 145 Table was marked as crashed and should be repaired

    解决MySQL error code 145 Table was marked as crashed and should be repaired的方法

    Table ‘xxx’ is marked as crashed and should be repaired 错误解决方法参考

    些东西都是从其他地方找来的一些解决MYSQL数据库这个错误的方法,并不一定适用于神迹数据库,仅仅供参考一下,具体的解决方法还是需要摸索。

    智慧生态环境解决方案 [Repaired].pptx

    智慧环保 环保物联网 水质、大气、土壤等领域的数据共享交换。

    shell脚本自动修复mysql损坏的表

    问题描述:最近查看mysql数据库服务器日志,老发现有表损坏的错误日志,比如:120724 7:30:48 [ERROR] /data/soft/mysql/libexec/mysqld: Table ‘./blog/wp_links’ is marked as crashed and last (automatic?...

    数据库MySQL表修复MyISAM

    数据库报错: SQLSTATE[HY000]: General error: 144 Table './db_jiangzi_video/cmf_jiangzi_items' is marked as crashed and last (automatic?) repair failed MySQL数据库表修复 MyISAM

    tcp网络调试助手

    用该软件可以快速的建立TCP的服务端和客户端 进行收发

    基于Socket 的网络调试助手

    基于Socket 的网络调试助手。帮助调试你的Socket环境是否畅通。

    Jlink问题汇总

    jlink常见问题的汇总,为初拥jlink调试stm32开发板的朋友使用。

    MySQL数据库表修复 MyISAM

    一:MySQL中MyISAM表损坏原因总结: 1、 服务器突然断电导致数据文件损坏;强制关机,没有先关闭mysql 服务;mysqld 进程在写表时被...3 、Error: Table ‘…’ is marked as crashed and should be repaired 。 4 、打开

    2009 达内Unix学习笔记

    其中 第一个是文件类型(-表普通文件,d表目录,l表软链接文件) 第2~4个是属主,生成文件时登录的人,权限最高,用u表示 第5~7个是属组,系统管理员分配的同组的一个或几个人,用g表示 第8~10个是其他人,除属组...

    mysql修复数据表的命令方法

    网站运行中mysql的数据表难免会出现类似"is marked as crashed and should be repaired"的错误,我们可以用下面这个命令修复

    SVM.rar_As One_fall

    An SVM model is a representation of the examples as points in space, mapped so that the examples of the separate categories are divided by a clear gap that is as wide as possible. New examples are ...

    fiddler2

    Are you curious about which cookies are being sent, or what downloaded content is marked as cacheable? <br>Microsoft Fiddler can help you answer these questions, and many more. Fiddler is an ...

    yaffs2源码文件

    is marked with file id and chunk number. These marking 'tags' are stored in the OOB (or 'spare') region of the flash. The chunk number is determined by dividing the file position by the chunk size. ...

    英文原版-Essential NMRCGP CSA Preparation and Practice Cases 1st Edition

    It includes advice on preparation, consultation skills, how the assessment is marked, and 12 practice CSA cases, along with advice on how candidates can create cases with which to practise and assess...

    Data Fusion- Concepts and Ideas

    Examples and Matlab code now appear on a gray background for easy identification and advancd material is marked with an asterisk. The book is intended to be self-contained. No previous knowledge of ...

    Lambda-Calculus and Combinators,an Introduction

    The λ-calculus and combinatory logic are two systems of logic which can also serve as abstract programming languages. They both aim to describe some very general properties of programs that can ...

Global site tag (gtag.js) - Google Analytics