Big Problem...

[egthareal]

My forum outgrew the database ( > 100MB) and, now everythings froze up. I can't access the adminCP to delete/prune threads - and everything is coming to a grinding halt. Someone please HELP!!! What can I do ?

--EG

[WhSox21]

Why is your database limited to 100MB?

[egthareal]

Dirty host

[WhSox21]

Can you not upgrade your plan? That's going to be you're only option I think at this point.

[Marco van Herwaarden]

If you still have access to the database in any other way (phpMyAdmin/SSH/Telnet) then you could empty the 'word' table. This one can get pretty big and is used for post searching. You can always later rebuild it.

[Princeton]

open another account elsewhere and have the host transfer contents

[egthareal]

The host is being extremely difficult.

Is there any way to manually backup the VB files, before I attempt anything?

Thx,
EG

Additionally - through PHPmyADMIN is there any way to specifically delete a single forum? B/c all I want to delete is my "newsgroup" forum.

Thx!

[Paul M]

You could ftp to the site and copy your vB files, but this won't help with the database.

Don't you have phpmyadmin or SSH/mysql access to your database to do as MarcoH64 suggested ?

[egthareal]

I do have access to PHPmyadmin.

Not sure what I can do from there??

I dumped the WORD table - but I'm still short 40mb. Really need to delete one forum that I had newsgroups in. Any idea on how to do that from phpmyadmin?

[Paul M]

Originally Posted by egthareal

I do have access to PHPmyadmin.

Not sure what I can do from there??

I dumped the WORD table - but I'm still short 40mb. Really need to delete one forum that I had newsgroups in. Any idea on how to do that from phpmyadmin?

You can also clearout the "postindex" table - it is also rebuilt when you re-index your posts. When you say "dumped" you do mean you deleted all the records ?