This is driving me absolutely crazy.... It has been mentioned here before with no fixes.

Basically, every so often with no consistency whats so ever, mysql forgets where the table are located and reverts to /tmp/ to find them. Obviously there are no tables there so it shows the only file in there vi.recover.

Simply shutting down mysql and starting it back up fixes the problem right away.

Again there is absolutely no consistency at all, but happens more often when we are in the office then not. It doesn't seem like one thing causes it either, we'll be doing a task all day and all of the sudden it'll go down.

I have tried binary & source with the same exact result.

We use mostly php to do anything with the DBs.