无法在mysql数据库中进行正常选择 [英] Cannot do normal select in mysql database

问题描述

我尝试对数据库进行正常选择，例如select * from xxx limit 0,30.

I try to do normal select on database, like select * from xxx limit 0,30.

但我收到此消息:ERROR 29 (HY000): File 'tablename.MYD' not found (Errcode: 13)

我尝试在 mysql 数据文件文件夹中搜索文件，我找到了.怎么会这样.

I try to search the file on mysql datafile folder, and I find it. How can this happen.

推荐答案

您可以使用 PhpMyAdmin 之类的工具访问数据库吗?

Can you access the database using a tool like PhpMyAdmin?

根据这个网站修复应该可以解决:

According to this site a full repair should solve it:

mysqlcheck --all-databases --auto-repair -ucojjohealth -p

如果这不能解决问题:

虽然上面的命令修复了在大多数情况下损坏的数据库，有可能获得此命令后的新错误消息:

While the above command repairs corrupted databases in most cases, there is a possibility of getting a new error message after this command:

错误:文件../diaendomet/users.MYD"未找到(错误代码:2)

error: File '../diaendomet/users.MYD' not found (Errcode: 2)

如果遇到上述错误消息，那么你的数据库已经严重损坏.修复你的数据库在这种情况下，你会需要使用第三方 MySQL 数据库恢复工具.MySQL 恢复实用程序提供先进的、完整的、和无风险的数据库修复修复损坏的 MySQL 的应用程序在维护数据库的同时数据的完整性.这些工具采用高端扫描机制全面修复损坏的MySQL 数据库.直截了当文档，这些工具用作不言自明和以修复为中心工具.

If you encounter the above error message, then your database has been corrupted badly. To repair your database in such situations, you will need to use third-party MySQL Database Recovery tools. MySQL Recovery utilities provide advanced, complete, and risk-free database repair applications that repair damaged MySQL database while maintaining the intactness of data. These tools employ high-end scanning mechanisms to comprehensively repair the corrupted MySQL databases. With to-the-point documentation, the tools serve as self-explanatory and repair-centric tools.

阅读更多:http://www.articlesnatch.com/Article/Resolving-Error-29-In-Mysql-Database/788529#ixzz1OlEpu62A

这篇关于无法在mysql数据库中进行正常选择的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！