"Praveen KS" <[EMAIL PROTECTED]> writes: > In a table of 20,000 records I am frequented with this error: > > Error 1034: > Incorrect key file for table: 'XXXX'; try to repair it > > Frequency of this error: Three or four times a week. > I am logging the data it was trying to insert or update. After I, > > repair table <tablename> > > if, I try to insert the same data.. its accepts without getting > corrupted.
Your tables are getting corrupted. You might have a software of hardware error. Since you are running an ALPHA release my guess is that you have a software problem. Upgrade mysql to a production release and see if that takes care of your problem. -- Per Andreas Buer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]