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" <ka...@el.net> >> >> 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. > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql