I've got a table in a MySQL database which currently stores stats from a website I developed....it has a primary key called id which is also set as unique and an index.

However, I noticed today that the stats stopped working...

The number of table rows was at 205,933....

When I tried to manually add more data to the table it stated that id 205,934 already existed and it couldn't add it because the column was a unique index. However id 205,934 doesn't exist.

After fiddling around removing a few rows and trying to add more, I now get the following error...

Can't open file: 'stats.MYD'. (errno: 145)

I assume that the table is corrupt....Does anyone know what may have caused the problem?

I'm running MySQL 3.23.32 running on Red Hat Linux