Re: Table fixed BUT...Re: Table crashed! Please help OT

2004-09-08 Thread Jim Grill
> Bingo. Yeah, that works very well. > Really appreciated. > > BTW, still curious about the reason of duplicate.:) > Any thoughts? > > Monet > Several thoughts; one of which is "Thank my lucky stars! I have my data back!" :-) Other, less significant thoughts include the possibility that some eso

Re: Table fixed BUT...Re: Table crashed! Please help

2004-09-08 Thread gerald_clark
Monet wrote: Hello there, I tried “REPAIR TABLE” to recovery the crushed temp table and that works. Thanks a lot. But, after reparation, there are some duplicated records generated. Is that because the temp table has no primary key? Or is because the table was crushed in the middle of query? Anyw

Re: Table fixed BUT...Re: Table crashed! Please help

2004-09-08 Thread Monet
Bingo. Yeah, that works very well. Really appreciated. BTW, still curious about the reason of duplicate.:) Any thoughts? Monet --- Jim Grill <[EMAIL PROTECTED]> wrote: > > Hello there, > > > > I tried "REPAIR TABLE" to recovery the crushed > temp > > table and that works. Thanks a lot. > > >

Re: Table fixed BUT...Re: Table crashed! Please help

2004-09-08 Thread Jim Grill
> Hello there, > > I tried "REPAIR TABLE" to recovery the crushed temp > table and that works. Thanks a lot. > > But, after reparation, there are some duplicated > records generated. Is that because the temp table has > no primary key? Or is because the table was crushed in > the middle of query?

Table fixed BUT...Re: Table crashed! Please help

2004-09-08 Thread Monet
Hello there, I tried “REPAIR TABLE” to recovery the crushed temp table and that works. Thanks a lot. But, after reparation, there are some duplicated records generated. Is that because the temp table has no primary key? Or is because the table was crushed in the middle of query? Anyway, I tried