如何解决“错误130(HY000):文件格式错误"的问题， [英] How to fix "ERROR 130 (HY000): Incorrect file format"
问题描述
当我对其中一张表进行查询时，数据库出现问题
I have a problem with my database when I made a query on one of my tables I get this error message
错误130(HY000):文件格式不正确
请如何解决?
推荐答案
尝试文章
try repair table , another good article
第一个链接的相关部分:
The relevant section from the first link:
MySQL数据库允许您定义其他MySQL存储引擎 用于不同的表.存储引擎是用于存储的引擎 并检索数据.最受欢迎的存储引擎是MyISAM和InnoDB.
MySQL database allows you to define a different MySQL storage engine for different tables. The storage engine is the engine used to store and retrieve data. Most popular storage engines are MyISAM and InnoDB.
MyISAM表-最终会损坏.这是生活中的事实.
MyISAM tables -will- get corrupted eventually. This is a fact of life.
幸运的是，在大多数情况下，MyISAM表损坏很容易修复.
Luckily, in most cases, MyISAM table corruption is easy to fix.
要修复单个表，请连接到您的MySQL数据库并发出:
To fix a single table, connect to your MySQL database and issue a:
repair TABLENAME
要修复所有问题，请执行以下操作:
To fix everything, go with:
/usr/local/mysql/bin/mysqlcheck --all-databases -uUSERNAME -pPASSWORD -r
很多时候，MyISAM表会损坏，甚至不知道 关于它，除非您查看日志文件.
A lot of times, MyISAM tables will get corrupt and you won't even know about it unless you review the log files.
我强烈建议您将此行添加到/etc/my.cnf配置文件中.它 一旦损坏，它将自动修复MyISAM表:
I highly suggest you add this line to your /etc/my.cnf config file. It will automatically fix MyISAM tables as soon as they become corrupt:
[mysqld]
myisam-recover=backup,force
这篇关于如何解决“错误130(HY000):文件格式错误"的问题，的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
