Cache overloaded, host banned DB

[Wayne Luke]

Running the install again will simply delete the database. This is why I recommend using queries on a functioning database to empty the two tables. I have no clue as to what the problem is here as the cache and cacheevent tables are transient data and will simply be rebuilt. I can only guess that the import failed somewhere along the way.

[astonishedman]

Okay, I imported the file with the cache and cacheevent tables emptied and truncated. When I go to my forum it is just a blank page.
http://www.uberdrivers.com/forum/

Not sure how to restore. Should I try to do a reinstall of the software? The latest I have is 5.4.0.

[Wayne Luke]

Personally, I would restore the database locally and delete the contents of the cache and cacheevents tables. Then create a new backup.

You can carefully delete the insert queries for the cache and cacheevent tables but if you delete too much it can make the entire file worthless.

[astonishedman]

Thank you for the response. I have posed the cloud option to the owner to consider. If we try to reinstall on current host the file limit for upload to the database is 1GB, so I will have to manually alter the file to reduce the size in half. So, even though it will be rebuilt, can I delete the cache table insert command and allow the cache table to be created empty just to try to get it up and running and then I can get into admin? Or will this cause the software to not work?

[Wayne Luke]

Your site will not work properly without the caching. You can clear the Cache in the AdminCP under Maintenance. You can delete the content of the cache and cachevent tables within the database but they will be rebuilt.

On a properly configured server, the cache is self-limiting and old entries will be deleted. A 2 Gigabyte database is really not that large. You need to find a new hosting provider that allows you to have a proper database if you expect your site to be able to grow. There is also the alternative of vBulletin Cloud where we won't put petty restrictions on your forum. You receive 100 GB of storage for your forums with Cloud.

[astonishedman]

We've been running vBulletin for a few years and recently it stopped working. I investigated and found that the database had been deleted. We contact the host company and they said it had gotten too large, using more than allotted resources so they deleted the database. They did export it to a file, though, so at least it isn't lost. I downloaded the 2GB file and found that the "cache" table is about 80% of the document. So a few questions:

1. Can I delete the INSERT for the cache table and re-install the database without it crashing the forum in any way?

2. Why is the cache table needed and can I opt not to have it fill up like this?