Database grown too large?

[flip]

It looks like at 150 mb, 1and1 cuts off your database's access. Thats the only thing that I can figure could be wrong here. The 'limit' is 100 meg and i let it go past that. I probably shouldn't have but I have no idea how to shrink the database...

If I can't access the db through vbulletin, how can i shrink the size? I have access to it through phpmyadmin.

Please help, my forums are completely down...

[flip]

Forgot to mention that 1and1 will not up the size of my database unless I get a dedicated server (which I can't do right now). THey even said they could not do it temporarily so I could fix the space issue...

[Steve Machol]

For now, you can empty the postindex and word tables with these queries:

truncate postindex;

truncate word;

Your search will not work thouhh unless you change to full text search, and even then they may count that space against your db limit.

[Andy Huang]

There's not a whole lot you can do actually...
Yes, you can delete records from your database to bring down the size, but by doing so, you will lose data (IE: posts / attachments / etc.).

For now, make a backup of your database via PHPMyAdmin and make sure you get it all (Open it up in notepad, the very end should be information of your "word" table). When you're done, it may be not too much help, but here are the more "non-essential" tables that you can empty (do NOT delete the tables, empty its content using TRUNCATE instead). Please note that once you remove content from these, there is no turning back, they're gone forever. Removing them COULD also cause side effects that I'm not aware of... but unfortunately that's what you must deal with if you are stuck there for now... I've left information on what I can so you know what you're removing, and hopefully they'll make 50mb for you so you can get back in:

adminlog -- Empties all your admin actions log.
attachmentviews -- the counts of how many times each attachment have been viewed
cpsession -- Control panel session... not too important, will be remade each time an admin/mod/super mod logs in to admin / mod cp.
cronlog -- scheduled task logs
deletionlog -- deletion logs
editlog -- edit logs (thread & posts)
externalcache -- external rss feed cache
forumread -- marking forums as read for db based forum read marking
humanverify -- human verify info (IE: UserA attempting to register, his captcha image should say 1234)... rather useless ot have if your site is not accessible and they'd need to re-do the registration anyways
moderatorlog -- moderator logs
postedithistory -- post edit history
profilevisitor -- who viewed whos profile n times
rsslog -- RSS logs for feeds coming in to your site.
search -- search result cache
session -- session data, everyone will need to relogin, and these will be re-created
spamlog -- post ids for spam
stats -- stats, this could be pretty big if your forum is old... unfortunately, they're gone forever
subscriptionlog -- who paid you how much when, for your reviewing pleasures only.
tagsearch -- tag search cache results
templatehistory -- template edit histories
upgradelog -- logs of when upgrade is being done
useractivation -- user need to verify their email, information are here, they can re-request if needed
userchangelog -- user change log (IE: I change my email from myemail@address.com to eh@Isuck.com)
word -- words index used in posts, used for searches

If you clear those, and makes up 50mb, first thing you should do is go in to admin cp and move your attachments, display pics, and what nots into the filesystem. They tend to take up the most space in database anyways. And then you should be able to free up some more space.

If that still doesn't work, then you will have to look for a different host, as there is no other way to reduce the size without losing more critical data, such as pm, post, attachments, etc.

[flip]

Alright, I'll try to empty the search tables and see if that helps enough.

I finally got an answer that it IS the db space and they cut me off. I'm trying to get them to let me back in for a bit so I can clean it up from inside VB.

I've searched around and haven't really found much of any info on archiving. Is there anything that can give me some hints on how to set up archiving to save space? or are there other better ways of saving space aside form moving attachments etc...?

[flip]

Is there any safe way to clean up old PM's through phpmyadmin? Looks like I've got almost 20 meg in there... Still not 50 mb tho... :(

[LindseyBc]

You could change hosts?

[haythamghareeb]

Is there any safe way to clean up old PM's through phpmyadmin? Looks like I've got almost 20 meg in there... Still not 50 mb tho... :(

Yes there is a mod for that. All you have to do is install it as a product and it will clean out all your PMs.

[flip]

Yes there is a mod for that. All you have to do is install it as a product and it will clean out all your PMs.

Problem is that I can't log in...

[flip]

You could change hosts?

im considering... any suggestions?

[LindseyBc]

http://www.vbulletin.com/forum/forumdisplay.php?f=11

[haythamghareeb]

Problem is that I can't log in...

You have access to PHPAdmin, right? Isn't it possible to empty PM table?

im considering... any suggestions?

I can give you my host if it's allowed.
1 FREE Domain Name for Life
1,500 Gigs Storage!
15,000 Gigs Data Transfer!
24/7 Award Winning Support!
Unlimited Databases
Unlimited Email/FTP Accounts
Blog, Forum & Photo Gallery
Fantastico (Over 35 Scripts)
JSP/ASP Available
Spam Protection- IMAP Support
Microsoft® Frontpage® Compatible
Dreamweaver Compatible
Unlimited add on domains Included FREE!
Ruby on Rails 6, PostGReSQL
MySQL 4+, PHP 4+
MySQL 5 & PHP 5.2+ Available!
Free Web Design Templates
Webmail (Horde and Squirrel)
:)

[flip]

Well I think I've found the best solution. I've purchased a virual server for $30 a month. Thing is that it only comes with about 10GB disk space so I'm going to keep my other web hosting account for the 250GB space and used the virtual server's 10GB for my database... Seems kinda backwards but it should work...