suspended account due to 1.7 gig database Need help@

[ryancooper]

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!!

[filburt1]

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.

[ryancooper]

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!

[Oblivion Knight]

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

[ryancooper]

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

[tpearl5]

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.

[Velocd]

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

[ryancooper]

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:

[Link14716]

run it again, shopuld fix that

[ryancooper]

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. . .