List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:January 24 2012 8:51am
Subject:Re: MYD, MYI and TMD files
View as plain text  
----- Original Message -----
> From: "kalin m" <kalin@stripped>
> 
> ok. thanks. i thought so. it's been about 8 hrs so far. and the TMD
> file is about half the MYD/MYI file. although MYI is about a gig smaller
> than the MYD. which one has the TDM to reach in size in order for the
> repair to be complete?

The MYI file contains only indices, which are pretty much disposable. The MYD contains the
actual data, and is what myisamcheck will be reading in order to salvage as much data as
possible. It will basically try to copy every record into the temp file, then switch out
the files and do a full reindexing run. It's not a bad idea to have a copy of your
original MYD file, just in case the repair doesn't quite yield what you'd hoped.


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
Thread
MYD, MYI and TMD fileskalin m23 Jan
  • Re: MYD, MYI and TMD fileskalin m24 Jan
    • Re: MYD, MYI and TMD filesMichael Dykman24 Jan
      • Re: MYD, MYI and TMD fileskalin m24 Jan
        • Re: MYD, MYI and TMD filesMichael Dykman24 Jan
        • Re: MYD, MYI and TMD filesJohan De Meersman24 Jan
          • Re: MYD, MYI and TMD fileskalin m26 Jan
            • Re: MYD, MYI and TMD filesJohan De Meersman27 Jan