`
ttitfly
  • 浏览: 620361 次
  • 性别: Icon_minigender_1
  • 来自: 杭州
社区版块
存档分类
最新评论

Table xxx is marked as crashed and should be repaired

MySQLSQLJavaCC++ 
阅读更多

 Caused by: java.sql.SQLException: Table '表名' is marked as crashed and should be repaired

解决办法：

 
  1. ./myisamchk -c -r 数据库表MYI文件的路径(例如：/home/mysql/var/crawlerfeedsky/aaaa.MYI)
  2. 如果还不行，就-f 强制修复 
分享到：
| Listener接口类
评论
1 楼 linkobe 2007-11-14  
太厉害了，这都知道，具体是什么原因。
发表评论

您还没有登录,请您登录后再发表评论

相关推荐

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

    nested exception is java.sql.SQLException: Table '.\discuz\cdb_threads' is marked as crashed and should be repaired ``` #### 错误原因分析 此错误出现的原因主要有以下几点： 1. **意外关闭**：如果MySQL...

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

    ### "Table ‘xxx’ is marked as crashed and should be repaired" 错误解决方法及分析 #### 背景介绍 在MySQL数据库管理过程中，遇到“Table ‘xxx’ is marked as crashed and should be repaired”这类错误时...

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

    在使用MySQL数据库的过程中，如果遇到提示“Table ‘XXX’ is marked as crashed and last (automatic?)”，这通常意味着指定的表已经遭受了损坏。在这种情况下，我们可以采取一些步骤来解决这个问题。下面详细地...

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

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

    MySQL数据库表修复 MyISAM

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

    tcp网络调试助手

    标题中的“tcp网络调试助手”是一款专为TCP网络通信设计的辅助工具，它允许用户便捷地设置服务端和客户端，以便进行数据的发送与接收。TCP（Transmission Control Protocol）是互联网协议栈中的一种面向连接的、可靠...

    基于Socket 的网络调试助手

    Socket编程是计算机网络编程中的重要组成部分，主要用于实现客户端与服务器之间的通信。在本文中，我们将深入探讨基于Socket的网络调试助手及其在确保Socket环境畅通无阻中的应用。 首先，让我们理解什么是Socket。...

    MYSQL数据库损坏

    3. 错误提示"Error: Table 'p' is marked as crashed and should be repaired"。 4. 打开表失败，提示"Can’t open file: ‘×××.MYI’ (errno: 145)"。 **三、预防MySQL表损坏** 1. 定期使用`myisamchk`检查...

    Google C++ Style Guide(Google C++编程规范）高清PDF

    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...

    2009 达内Unix学习笔记

    集合了 所有的 Unix命令大全 ...telnet 192.168.0.23 自己帐号 sd08077-you0 ftp工具 192.168.0.202 tools-toolss ... 各个 shell 可互相切换 ksh:$ sh:$ csh:guangzhou% bash:bash-3.00$ ... 命令和参数之间必需用空格隔...

    mysql数据库索引损坏及修复经验分享

    首先，MySQL的错误日志中可能会出现类似“Table './dedecmsv4/dede_archives' is marked as crashed and should be repaired”的信息，这表明某个表（如dede_archives）出现了索引损坏。这种情况可能由于数据库...

    WebBrowserEx

    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.

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

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

    BmdThread_1.9_XE4_Win32

    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.

    英文原版-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...

Magicbox
Global site tag (gtag.js) - Google Analytics