Results 1 to 6 of 6
Feb 12, 2001, 17:28 #1
- Join Date
- Feb 2001
- 0 Post(s)
- 0 Thread(s)
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 LinuxGuntrisoft Ltd