Robert,

Stupid question .... Are you running any sort of Backup progran such as BackupExec or NT Backup?  If so, that may be your problem. You must either exclude the folder where the DB's are located or make absolutly sure the backup program does not try to "Lock" the files in that folder. MySQL becomes VERY unhappy whe some other program trys to lock the files and "blows itself up".  The MySQL logs files will indicate that something horrible is happening when a program locks the file and then an attempt is made to write to the db.

Or .... I have no other thoughts at this time.

Dan S.

Dan,

I've not specifically resolved the issue, nor has it recurred since my posting. Unfortunately it just seems to happen periodically - well, twice thus far, but that's enough to make it "periodic".

I plan to run a low level HDD check on that server just to be sure that I don't have some problem lurking at that level. I'd expect to see other problems on that box if I had serious HDD problems, and this is the only file loss problem that I've had.

I will let you know if I find anything, as I'd sure like to be able to trace this down to a probable cause!

Thanks,

Robert