thanks. it took about 15 hrs. but right now everything seems ok. does
the check last as long as the repair?
On 1/24/12 3:51 AM, Johan De Meersman wrote:
> ----- 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.