Re: *.MYI was corrupted with OS crash when lots of rows were inserting

2007-03-06 Thread Duncan Hill
On Tuesday 06 March 2007 01:51:38 xian liu wrote: Hi all, when I insert many records into a myisam type table, at the same time, unplugged the power cable, the os crash, I found several *.MYI file was corrupted, but can use repair or myisamchk to repair those table. Is there any way to

*.MYI was corrupted with OS crash when lots of rows were inserting

2007-03-05 Thread xian liu
Hi all, when I insert many records into a myisam type table, at the same time, unplugged the power cable, the os crash, I found several *.MYI file was corrupted, but can use repair or myisamchk to repair those table. Is there any way to avoid this happen? my env: OS---Linux-2.6.9smp for