Big Problem...
 

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

Why is your database limited to 100MB?

Dirty host :(

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

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.

open another account elsewhere and have the host transfer contents

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!

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 ?

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 ?

I used the "empty" command.

That is correct right? BTW thanks so much for your help thusfar.. I'm getting closer.

Like the others, I strongly suggest you find another host. One that caps your database at only 100 MB will not allow your site to grow.

Thank you and after this problem - I will immediately be finding another host. Just need to regain hold of the current database at this time. Then concentrate on moving.
--EG

I'm not familiar with the "empty" command.

I just use "DELETE FROM xxxxx" where xxxxx is the table name.

Anyone know about using the "empty" command? Is this okay?

Thx,
EG

'empty' is not a MySQL command. Maybe it is named like that in your server software. It will probably implement a 'DELETE FROM table' or 'TRUNCATE TABLE table' command.

EMPTY is the command in phpmyadmin that I found. Do you know of any safe command in phpmyadmin that I could possibly use?

Thanks

If I was to execute this "delete from" command in CRT what would it look like?

Anyone?

Just use the 'Empty' command in phpMyAdmin.

Yes, the empty command in phpmyadmin would do the trick.


Edit : LOL - MarcoH64 beat me to the reply. :)

Well i actually already kinda answered the same in my post at the top of this page.

All is WELL!!!!

A BIG BIG Thank you to everyone who helped!

--EG

Try repairing your database.