Thursday, July 14, 2011

How to reslove error- “ERROR 29 (HY000): File 'tablename.MYD' not found (Errcode: 13)”

Have you encountered the following error message:

ERROR 29 (HY000): File 'tablename.MYD' not found (Errcode: 13)

Three conditions in which this error message occurs:
  1. When MYD-file permission denied.
  2. When the table is corrupt.
  3. When the .MYD file lost.

Choose Any Solution As Per Your Requirement:
  1. Check the permissions of the MYD-file and the directory. Putting files in the MySQL data directory or some other path where the server has read permissions.
  2. Execute the repair table command to repair corrupt table. REPAIR TABLE rebuilds the entire table and index.
  3. You can restore your database from your regular updated backup.

Note: It is best to take a backup of a table before applying a table repair operation.

Either the above command repairs corrupted MySQL database or there is a possibility of getting a new error message after this command:

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

If you got this error message, it means MySQL database has been severely corrupted. In this case you can use Third party MySQL Recovery Software. These software repairs corrupt MySQL database in case of no backup. The Software repairs .myi, .myd, .frm (MyISAM database engine) files as well as .ibdata, .ibd, .frm (InnoDB database engine) files.

Note: Always remember that use these software on the copy of the corrupt database file. If anything went wrong, it will affect only duplicate copy of the database not the original one.

There are uncountable MySQL database errors that could be the reason of MySQL database corruption. There is no surety that every recovery software repairs corrupt MySQL database after all MySQL database error. So I will suggest you to first try demo version & take a fair idea about the software after that purchase it.

No comments:

Post a Comment