Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

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

by japhy (Canon)
on Nov 18, 2008 at 13:49 UTC ( [id://724268]=note: print w/replies, xml ) Need Help??


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.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://724268]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others having an uproarious good time at the Monastery: (6)
As of 2024-04-23 14:19 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found