Sounds like it's corrupted for good. If you don't have a backup then i don't believe there is any other way you can retrieve the messed up tables. Sorry...

n.b. check your hardware, you may find you have a hard drive that will fail soon.