Re: MYD, MYI and TMD files

2012-01-27 Thread Johan De Meersman
- Original Message - > From: "kalin m" > > thanks. it took about 15 hrs. but right now everything seems ok. does > the check last as long as the repair? No, a check (myisamcheck -c or "check table" in sql) is a read operation that verifies structures, pointers and such but makes no chan

Re: MYD, MYI and TMD files

2012-01-26 Thread kalin m
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" >> >> ok. thanks. i thought so. it's been about 8 hrs so far. and the TMD >> file is about h

Re: MYD, MYI and TMD files

2012-01-24 Thread Johan De Meersman
- Original Message - > From: "kalin m" > > 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 M

Re: MYD, MYI and TMD files

2012-01-23 Thread Michael Dykman
I couldn't say. I have not had particularly good luck doing MyISAM repairs. - md On Mon, Jan 23, 2012 at 11:49 PM, kalin m wrote: > > 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. w

Re: MYD, MYI and TMD files

2012-01-23 Thread kalin m
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? thanks. On 1/23/12 11:27 PM, Michael Dykman wrote: > This is

Re: MYD, MYI and TMD files

2012-01-23 Thread Michael Dykman
This is still the list although more quiet than it used to be. Repairing a table is already a fragile process.. I would not try to interrupt it if the data has no backup. - michael dykman On Mon, Jan 23, 2012 at 11:04 PM, kalin m wrote: > > > hey. this list used to be pretty active. did anyth

Re: MYD, MYI and TMD files

2012-01-23 Thread kalin m
hey. this list used to be pretty active. did anything change? is there another place to ask questions like these? thanks... On 1/23/12 5:02 PM, kalin m wrote: > > > hi all.. > > i started a repair on a table that has an MYD file of 9.2 gigs. the MYI > file is 7.7 gigs. the TMD file, which i