Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

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

by japhy (Canon)
on Nov 18, 2008 at 13:49 UTC ( #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?
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
Node Status?
node history
Node Type: note [id://724268]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (4)
As of 2014-10-26 03:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (149 votes), past polls