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

Great . . .

I just suspended your account because you said you were
going to prune your database. You went ahead and ran a
repair on the database and the file size of the database
has also gone up instead of down. The database is now
1.8GB. The repair commands you were running brought the
server down twice which caused a lot of downtime for over
200 customers. :eek:

Repair optimizes the database, too. If anything, after the query was done it should have greatly (well not greatly) reduced your db size.

Well either way I am now jsut trying to get them to un-suspend me so I can "hopefully" salvage the remander of the site. Looks Like i have a looooong night ahead of me! LOL

If that's shared hosting then you'll need to find a dedicated server quickly. No sane host will let you use that much space.

I would start with your searchindex

screw everything else

493.8 MB is my search index of a 1.1 gig database. If you got to do something start there.

400,000 USENET posts? Get rid of them, since most members don't look at them much.

too late they want 200 bucks to repair the database. Looks like i am starting from scratch. . .

If they have a dedicated server plan ask them if you buy it from them if they will transfer the database to it.

dedicated server runs over 100 bucks a month. I can'f afford that:(

Yes, but my logic is, if you can have them move it for 100, you can get the database backed up, and find a cheaper host. see my logic?

200 bucks to repair the database? That's steep. Are you sure they can charge you for that?

Do i really have a choice? It's either that, buy a dedicated server or delete it. . . I am trying to get into the account so I can at least grab the emails of my forum memebrs. I have a sql backup from 3 months ago, better than nothing i guess. . .

AHHHH!! Gotcha. That is a grat idea!

let us know if it worked ^_^

I will. Thanks you all for your help!

Delete the search index, delete the newsgroup forums, then run optimise one table at a time. This should stop their server from dying (assuming they let you restart it). Prune all posts with no replies for 90 days. Re-run optimise and you should have a much smaller db. For this size db I would be using phpmysqladmin - definitely not repair.php

If you have such a long forum, why don't you have ads on your site to pay for it?

that means its time to get a dedicated server.. MOST host out there give you xyz diskspace and that space is included with mysql.. i guess there are some cheap hosts out there that will suspend customers accounts even though they are under their alloted diskspace..

i'd move to a dedicated server if i were you, its only a matter of time when it gets back up to 1.7.gb.

Well it looks like I am ++++ out of luck. I have to start over from scratch. QUESTION:

If i run my backup via PHPMYADMIN in the SQL forum everything should come back correct??

LOL, definitely not. PMA is unreliable even for small dumps.

Great. . . How would I get my backup to the database then?

search for backup over on the .com site. The command line way to do it is over there.

Amy

http://www.vbulletin.com/manual/movingservers.html (can type it in my sleep now :()

Well guys I had to drop the database and start over from scratch. I don;t have the time or will to try to save it.

I want to thank everyone who helped me I really do appreciate it!

Ryan :)

what a shame...

I feel your pain. :(

Ok guys I have another question. Luckely i found a backup from last month where the databse is only 200 and some megs.

What I old like to do is delete the attachments and search tables BEFORE I try to load the backup.

How can I open the .sql file on my local windows pc and remove the attachments table?

This alone is over 200 megs and should let me properly upload my backup.

Any help is appreciated.

Thanks

ryan,
is the database compressed, or is it just the plain sql database backup ?
if it's plain sql then it'll be in plain text format.

if you cant figure a way to do this then as a fellow Disney board owner, if you dont mind me having your database, I can download it onto my home server delete what ever you want, Attachments, word, index etc and then upload it for you.

If you want any help, either PM me or you can find me at my site in my profile.

looks like he doesnt have his copyright....

WHO doesn't have copyright.... PLEASE Explain!!!!!!!!!!!