I had the same problem, but only once so far.

I tried the repair table, etc. without any success.

The only way I was able to function again was to have the host server provider import a back-up that they had fortunately done.