我是在centos6.2下跑ecshop的
报错如下
Table './ecshopExtned/mmbk_order_workflow' is marked as crashed and should be repaired.
查配置文件、etc/my.cnf找到data目录,默认/var/lib/mysql/ecshopExtned/mmbk_order_workflow.MYI
找myisamchk工具which mysql 在同级目录下面,默认/usr/bin/myisamchk
myisamchk -c -r /var/lib/mysql/ecshopExtned/mmbk_order_workflow.MYI
结果是
- recovering (with sort) MyISAM-table '/var/lib/mysql/ecshopExtned/mmbk_order_workflow.MYI'
Data records: 146260
- Fixing index 1
Found block that points outside data file at 33333220
备份一下数据,完成
分享到:
相关推荐
解决MySQL error code 145 Table was marked as crashed and should be repaired的方法
些东西都是从其他地方找来的一些解决MYSQL数据库这个错误的方法,并不一定适用于神迹数据库,仅仅供参考一下,具体的解决方法还是需要摸索。
主要介绍了Mysql中Table ‘XXX’ is marked as crashed and last (automatic?)问题解决方法,需要的朋友可以参考下
智慧环保 环保物联网 水质、大气、土壤等领域的数据共享交换。
一:MySQL中MyISAM表损坏原因总结: 1、 服务器突然断电导致数据文件损坏;强制关机,没有先关闭mysql 服务;mysqld 进程在写表时被...3 、Error: Table ‘…’ is marked as crashed and should be repaired 。 4 、打开
网站运行中mysql的数据表难免会出现类似"is marked as crashed and should be repaired"的错误,我们可以用下面这个命令修复
用该软件可以快速的建立TCP的服务端和客户端 进行收发
基于Socket 的网络调试助手。帮助调试你的Socket环境是否畅通。
问题描述:最近查看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
jlink常见问题的汇总,为初拥jlink调试stm32开发板的朋友使用。
Altered source versions must be plainly marked as such, and must not be misrepresented as being the original software. 3. This notice may not be removed or altered from any source distribution.
All of a project's header files should be listed as descentants of the project's source directory without use of UNIX directory shortcuts . (the current directory) or .. (the parent directory). For...
Altered source versions must be plainly marked as such, and must not be misrepresented as being the original software. 3. This notice may not be removed or altered from any source distribution.
集合了 所有的 Unix命令大全 ...telnet 192.168.0.23 自己帐号 sd08077-you0 ftp工具 192.168.0.202 tools-toolss ... 各个 shell 可互相切换 ksh:$ sh:$ csh:guangzhou% bash:bash-3.00$ ... 命令和参数之间必需用空格隔...
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...