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 avoid this happen?
Don't pull the power cable? MyISAM is not a transaction safe table type. Consider InnoDB instead, and provide power protection (and battery backed disk controllers) so that a power outage doesn't affect you as badly. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]