So I came to work this morning and instantly get hammered by a problem. That alone is quite ordinary, but the catch is that I'm having trouble figuring this one out, so here I am.
I have a table by the name of 'users' which is apprently unusable due to the apparent loss of it's .MYI file. When I try to access the table, it claims it can't find users.MYD, but upon checking the files, it's present and .MYI is not -- so I'm continuing under the assumption that it can't find .MYD due to the missing .MYI file.
So my question is thus: What would cause that file to be deleted? Access is limited on the server and root access even moreso, so I can't imagine it being manually deleted. Could it have been automatically removed if it breached it's set max keyfile length? But the even more important question is: can I correct the problem without losing all the information in the table?
Any help is greatly appreciated.