suspended account due to 1.7 gig database Need help@
 

I just got a email from my host today telling me my account was suspended diue to a large 1.7 gig database. I need some ideas peraps hacks I can install that will help drop this number down! Please!!!

I am looking for the attachments as files hack now.

Thanks!!

Turn off avatars, attachments, limit post sizes, prune old posts, remove hacks that add bulk to the database, turn off searching. Should make database size plummet.

thanks filburt1 I will try that. I know people will not like to loos the avatar so I think I have to leave that alone. I jsut noticed i had over 400,000 posts in a usenet group. Hopefully pruning that will help!

1.7 gig database..? :eek:
A lot of hosts would have suspended your account ages ago..

LOL I don;t think they noticed!! I just got the email today.

First, prune old messages, then reindex the search index if you don't want to turn it off completely. The search index is usually a big chunk of the database.

Make sure you regularly optimize the attachments table, through phpmyadmin, as I once found when my attachment table was reading 50+ megs, that once I optimized it, it had gone down to under 5mb.

Use repair.php ;)

OK Well i used the rep[air.php and got now have this error on my pages/. . .

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT post.postid, post.userid, post.pagetext, post.topic, user.username as username, attachment.attachmentid,attachment.filename,attach ment.visible AS attachmentvisible,attachment.counter
FROM post LEFT JOIN user ON (post.userid = user.userid) LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE threadid=11529 ORDER BY postid LIMIT 1
mysql error: Can't open file: 'post.MYI'. (errno: 144)

mysql error number: 1016

Date: Wednesday 09th of April 2003 06:46:31 PM
Script: http://www.talkdisney.com/forums/
Referer:

run it again, shopuld fix that

OK i will try. Thanks! I am dying here!!! I almost uploaded my backup from 3 months ago. Glad i read this first!! Thanks

FYI when I run it i do get a lot oferrors saying tanble is corrupt. . .