----- 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

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.