Rectifying can't Open File:'tablename.myd'. (errno: 145) In Mysql

MySQL is a popular RDBMS (Relational Database Management System)

, which runs as server offering multi-user access to various databases. It uses two major storage engines, MyISAM and InnoDB to store and manage your valuable data. The MyISAM storage engine uses three types of files to hold data- .myd, .myi, and .frm. In case any of these files gets damaged, you can not access the data from your MySQL database and come across critical data loss situations. In such critical situations, you need to opt for MySQL recovery to get your valuable data back, if backup is not in place.

In a practical scenario, you may come across the below error message when you try to open a .myd file of your MySQL database:

"Can't open file: 'TableName.MYD'. (errno: 145)"

After the above error message, you can not access the file. The same error occurs every time, when you attempt to the problem file. To extract corrupted files from the database in such situations, you need to repair MySQL database using appropriate tools.

What Causes 'Can't open file..' Error in MySQL?

The above behavior of MySQL database generally caused if the table is corrupted. The error indicates that the table, which is used to store the sessions, is damaged. Such situations can be caused by numerous reasons, such as file system errors, virus infection, application bugs or malfunction, hardware problems, and unexpected system shutdown.

Resolution

In order to sort out this problem of MySQL database, try out any of the below solutions:

If corruption is not causing the loss of your precious data or the significant downtime, restoring the data from most recent backup is the best option to try fixing the issue.

Allocate additional space to your database. It can be done by upgrading your hard drive.

Try running the below MySQL query on the database using phpMyAdmin:

REPAIR TABLE TableName

The above mentioned methods can help you to recover MySQL database in a number of the database corruption scenarios.

However, if they can not sort out the problem, you need to use advanced and powerful third-party applications.

The repair mysql applications employs high-end database scanning mechanisms to ensure absolute recovery. They are incorporated with interactive and self-descriptive graphical user interface to offer easy and quick recovery.

Database Recovery for MySQL is an efficient and comprehensive utility to offer assured recovery in all MySQL database corruption scenarios. The mysql database repair software repairs and restores all files of both MyISAM and InnoDB storage engines. It is compatible with MySQL 5.x and 4.x.

by: Advika Singh

POST COMMENT

Name Tag Can Be Made Just The Way You Want It Name Badges Have More Uses Than You Might Think! Name Labels Can Get You Out Of A Sticky Situation! CONAREC 2010 irá discutir o destaque mundial do Brasil no relacionamento com o cliente. O país está na moda e todos podem ganhar com isso! Name Tags Are As Relevant As Ever They Were Today Best Method For Changing Domain Names-Get It Right What Is A Domain Name? Which top-level domain (TLD) to choose? Getting Real Action With Parked Domains How To Choose a Domain Name Cheap Domain Names And Domain Name Registrations Domain Registrars - Domain Register Domain Registration India @ 499