Re^4: Read a mysql .MYD file without a working .MYI file?

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.	[reply]

In Section Seekers of Perl Wisdom