my experience with corrupted tables is usually followed by a failed harddrive ....aka the disk may be diing ...
-- Quoting Jon Wagoner <[EMAIL PROTECTED]>: > I am running MySQL 4.0.16 on a Red Hat 7.3 server. I am having problems > with tables periodically getting corrupted. The one it happens most often > on is a table I use for logging various status messages. This table > receives mostly inserts, and very few selects. It is about 400MB in size, > with about 1.3M rows. I just had it happen to another table, that receives > mostly selects, and few inserts or updates. It is only about 60MB in size, > with about 95k rows. Both of these tables rarely have deletes. > > The last time, I believe the error message said something about the index > being the wrong size. Sorry I didn't write it down, but I was in a hurry to > get things working again. Can anyone provide some help on this problem? > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]