今天进网站的时候突然打不开,进数据库一看,好几个表出现利用TMD表“is marked as crashed and last (automatic?) 错误,马上去网上查看资料,查看的资料说把TMD文件改成MDY文件,再用myisamchk -r *.MYI修复,修复了好几次,不是不行。根据MYSQL提示修复,表是修复了。网站也可以打开了。但是当我再次用myisamchk -r 修复表的时候,又出现TMD文件了。又变回修复前了。网站也打不开了。
因修复之前整个数据文件进行了备份,就想,把数据库文件放在其它的盘用myisamchk -r 修复所以表,这次没有出错,我知道没问题了,再把MYSQL配置文件指向新的数据,启动MYSQL,打开网站一切正常了。
想不到这次的正直问题是硬盘有问题。
弄了几个小时,原来就这问题。
分享到:
相关推荐
主要介绍了Mysql中Table ‘XXX’ is marked as crashed and last (automatic?)问题解决方法,需要的朋友可以参考下
解决MySQL error code 145 Table was marked as crashed and should be repaired的方法
些东西都是从其他地方找来的一些解决MYSQL数据库这个错误的方法,并不一定适用于神迹数据库,仅仅供参考一下,具体的解决方法还是需要摸索。
智慧环保 环保物联网 水质、大气、土壤等领域的数据共享交换。
问题描述:最近查看mysql数据库服务器日志,老发现有表损坏的错误日志,比如:120724 7:30:48 [ERROR] /data/soft/mysql/libexec/mysqld: Table ‘./blog/wp_links’ is marked as crashed and last (automatic?...
数据库报错: SQLSTATE[HY000]: General error: 144 Table './db_jiangzi_video/cmf_jiangzi_items' is marked as crashed and last (automatic?) repair failed MySQL数据库表修复 MyISAM
用该软件可以快速的建立TCP的服务端和客户端 进行收发
基于Socket 的网络调试助手。帮助调试你的Socket环境是否畅通。
jlink常见问题的汇总,为初拥jlink调试stm32开发板的朋友使用。
一:MySQL中MyISAM表损坏原因总结: 1、 服务器突然断电导致数据文件损坏;强制关机,没有先关闭mysql 服务;mysqld 进程在写表时被...3 、Error: Table ‘…’ is marked as crashed and should be repaired 。 4 、打开
其中 第一个是文件类型(-表普通文件,d表目录,l表软链接文件) 第2~4个是属主,生成文件时登录的人,权限最高,用u表示 第5~7个是属组,系统管理员分配的同组的一个或几个人,用g表示 第8~10个是其他人,除属组...
网站运行中mysql的数据表难免会出现类似"is marked as crashed and should be repaired"的错误,我们可以用下面这个命令修复
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 ...
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 ...
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. ...
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...
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 ...
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 ...