4WebHelp
 FAQ  •  Search  •  User Groups  •  Forum Admins  •  Smilies List  •  Statistics  •  Rules   •  Login   •  Register
Toggle Navigation Menu

 Can't open file: 'opers.MYD'. (errno: 144)
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic
Author Message
thess
Guest





PostPosted: Fri Jan 11, 2002 10:44 pm (15 years, 9 months ago) Reply with QuoteBack to Top

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?
OfflineFind all posts by Anonymous
jayant
Team Member



Joined: 07 Jan 2002
Posts: 262
Location: New Delhi, India

PostPosted: Sat Jan 12, 2002 3:15 pm (15 years, 9 months ago) Reply with QuoteBack to Top

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.

________________________________
Jayant Kumar
Member of the 4WebHelp Team
Nibble Guru - Computing Queries Demystified
GZip/ Page Compression Test
OfflineView User's ProfileFind all posts by jayantSend Personal MessageVisit Poster's WebsiteYahoo MessengerMSN Messenger
jayant
Team Member



Joined: 07 Jan 2002
Posts: 262
Location: New Delhi, India

PostPosted: Sat Jan 12, 2002 3:27 pm (15 years, 9 months ago) Reply with QuoteBack to Top

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

________________________________
Jayant Kumar
Member of the 4WebHelp Team
Nibble Guru - Computing Queries Demystified
GZip/ Page Compression Test
OfflineView User's ProfileFind all posts by jayantSend Personal MessageVisit Poster's WebsiteYahoo MessengerMSN Messenger
Display posts from previous:      
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic


 Jump to:   




You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot edit your posts in this forum.
You cannot delete your posts in this forum.
You cannot vote in polls in this forum.


Page generation time: 0.048189 seconds :: 17 queries executed :: All Times are GMT
Powered by phpBB 2.0 © 2001, 2002 phpBB Group :: Based on an FI Theme