Can't open file: 'opers.MYD'. (errno: 144)

Guest

i'm using phpmyadmin to manage my database and when i try to open the table "opers" this error appears. Have I lost all data? What can I do?

Posted: Sat Jan 12, 2002 3:15 pm (22 years, 3 months ago)

In MySQL, there are 3 types of files .frm, .myi, .myd for each table in a database.
.frm has the defination of each table, i.e attributes,their types etc....
.myi stores the indexed table
.myd has the whole data

Since there is no .myd file, this means that all data has been lost. If you have data on paid host then you can ask them for last backup. Paid hosts take backup on weekly/daily basis.

When a file is deleted from harddisk it can still be recovered back until the data has been overwritten or harddisk defragmented. For windows, you can install Norton Utilities to recover data. There should be many similar applications that do the same job on Linux. Try searching Google or SourceForge.net for similar applications for linux if you are unable to find any.

Posted: Sat Jan 12, 2002 3:27 pm (22 years, 3 months ago)

In MySQL, Error code 144 or Unknown error 144 means:
144 = Table is crashed and last repair failed