johnnyb
08-16-2004, 11:07 PM
Hi,
I keep getting an error: "Cannot Find File 'tablename.MYI' (errno: 2)"
It appears that the index files, (.MYI files), are being deleted for all of my tables! I think it's happening during an insert operation, however it is not happening every time an insert is done.
Now here's the kicker: I'm using InnoDB tables, which I don't think even use .MYI files!
Has anyone else experienced problems like this? I had posted to the thread http://www.codingforums.com/showthread.php?t=8778 last fall and thought I had fixed the problem, but I am encountering the problem again.
If anyone has any ideas it would be great. I keep having to restart the MySQL server every few days.
Thanks,
JB
I keep getting an error: "Cannot Find File 'tablename.MYI' (errno: 2)"
It appears that the index files, (.MYI files), are being deleted for all of my tables! I think it's happening during an insert operation, however it is not happening every time an insert is done.
Now here's the kicker: I'm using InnoDB tables, which I don't think even use .MYI files!
Has anyone else experienced problems like this? I had posted to the thread http://www.codingforums.com/showthread.php?t=8778 last fall and thought I had fixed the problem, but I am encountering the problem again.
If anyone has any ideas it would be great. I keep having to restart the MySQL server every few days.
Thanks,
JB