http://www.perlmonks.org?node_id=724268


in reply to Re^3: Read a mysql .MYD file without a working .MYI file?
in thread Read a mysql .MYD file without a working .MYI file?

Oh, I have the space. I also made a copy of the temporary file (.TMD or whatever). But actually, good news: I repaired it from the command-line using myisamchk --safe-repair and it worked.

Jeff japhy Pinyan, P.L., P.M., P.O.D, X.S.: Perl, regex, and perl hacker
Nos autem praedicamus Christum crucifixum (1 Cor. 1:23) - The Cross Reference (My Blog)
  • Comment on Re^4: Read a mysql .MYD file without a working .MYI file?

Replies are listed 'Best First'.
Re^5: Read a mysql .MYD file without a working .MYI file?
by Anonymous Monk on Dec 01, 2008 at 22:11 UTC
    I had a similar issue where the .MYI file ended up on a bad block on disk. For me, I had similar tables and just moved the old .MYI to another name, then copied the .MYI from another table into its place. Then I ran REPAIR table db.table extended in the mysql client. Problem solved.