"Post" table marked as crashed.....

[dimples]

I have a corrupt table....the "posts" table, and vbulletin cannot repair it. I have also tried repairing in phpmyadmin with no luck.

Is there any chance at all of repairing it? If I don't have a back-up, am I out of luck?

[SEOvB]

hmm, probably. Are you getting any other errors other than its corrupt?

[dimples]

I am getting numerous errors but they are all relating to the post table being corrupt.

example:

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT COUNT(*) AS count
FROM ****_forumsinfraction AS infraction
LEFT JOIN *****_forumspost AS post ON (infraction.postid = post.postid)
LEFT JOIN *****_forumsthread AS thread ON (post.threadid = thread.threadid)
WHERE infraction.userid = 1;

MySQL Error : Table 'post' is marked as crashed and last (automatic?) repair failed
Error Number : 1195
Date : Monday, September 29th 2008 @ 04:24:31 PM
Script : **********************
Referrer : ****************
IP Address : *********
Username : *******
Classname : vB_Database

--------------- Added 1222730715 at 1222730715 ---------------

Ok, my host has helped me out with repairing the table.....phew!

Now, what started this whole thing was a message from them stating we are overloading the server and need to optimize it. Thay have put a limit on the site therefore i am getting all kinds of the following server errors

This error means that the web server is currently unable to handle your request due to a temporary overload.
Please try to reload the webpage in a few seconds.

They also stated my database was too big at 419Mb in size.

So I have optimized the tables....I have disabled all of the mods I had installed (probably about 15 or so)

So what next? Why is m y database so big? I don't have that big of a forum I didn't think. We average about 40-60 members visiting a day and have around 100 active members, ect. It;s not that big.

Does anyone have any suggestions on what to do next so my server will lift the restriction? I'm not so sure where to go from here now that I have disabled all the mods.

Thank you in advance.

[SEOvB]

do you have attachments or images stored in the database, if so move them to the file system.

After that if you are on a VPS or have access to configuration files, a server optimization may be needed and you can post for one at vBulletin.com and the friendly staff there will help with it when they get a chance

[dimples]

Thank you for your help FRDS!