----- 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. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql