PDA

View Full Version : Big Problem...


egthareal
05-23-2005, 07:06 AM
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
05-23-2005, 07:36 AM
Why is your database limited to 100MB?

egthareal
05-23-2005, 07:57 AM
Dirty host :(

WhSox21
05-23-2005, 08:00 AM
Can you not upgrade your plan? That's going to be you're only option I think at this point.

Marco van Herwaarden
05-23-2005, 10:51 AM
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
05-23-2005, 11:37 AM
open another account elsewhere and have the host transfer contents

egthareal
05-24-2005, 02:06 AM
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
05-24-2005, 02:15 AM
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
05-24-2005, 02:30 AM
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
05-24-2005, 02:38 AM
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 ?

egthareal
05-24-2005, 02:49 AM
I used the "empty" command.

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

filburt1
05-24-2005, 02:57 AM
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.

egthareal
05-24-2005, 02:59 AM
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

Paul M
05-24-2005, 03:01 AM
I'm not familiar with the "empty" command.

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

egthareal
05-24-2005, 03:24 AM
Anyone know about using the "empty" command? Is this okay?

Thx,
EG

Marco van Herwaarden
05-24-2005, 04:53 AM
'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.

egthareal
05-24-2005, 06:57 AM
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?

egthareal
05-26-2005, 04:37 AM
Anyone?

Marco van Herwaarden
05-26-2005, 05:32 AM
Just use the 'Empty' command in phpMyAdmin.

Paul M
05-26-2005, 05:34 AM
Yes, the empty command in phpmyadmin would do the trick.


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

Marco van Herwaarden
05-26-2005, 05:44 AM
Well i actually already kinda answered the same in my post at the top of this page.

egthareal
05-26-2005, 04:31 PM
All is WELL!!!!

A BIG BIG Thank you to everyone who helped!

--EG

WhSox21
05-26-2005, 04:34 PM
Try repairing your database.