Reducing DB Size?

[EagleMark]

Howdy,

My hosting service limits database size to 1Gb. DB is now at 1.9Gb. Largest table in DB is vb_filedata at 1.7 Gb. Obviously this is too large. I inherited this site so figuring this out is a crash course in mysql and vbulletin for me. I don't know enough to know what I don't know. So I'm looking for assistance.

Using limited skills I've looked at the contents of vb_filedata table. It appears to be a list of all attachments on the forum. Is this correct? Whoda thought it would get so large? Can I reduce the size of this table without losing the associations with forum posts?

I am unable to access any control panels at this time. Hosting service is preventing any DB access which seems to prevent any of the site from loading properly. Any suggestions on how to use any the tools normally accessed in the control panels?

Thanks

[Dave]

If your attachments, avatars, profile pictures are all served in the database right now then you should definitely move them to your filesystem to decrease the size of your database. Just make sure to run the database optimize/repair script in the AdminCP under the maintenance menu group afterwards.

https://www.vbulletin.com/docs/html/...rage_db_to_fs1
https://www.vbulletin.com/forum/foru...to-file-system

In my opinion, if the host has a database size limit of (only!) 1GB, you should look into moving to a different hosting company.

[EagleMark]

Thanks for the reply,

The attachments, avatars, and profile pictures may well be served in the database right now. I don't know how to access the control panel to check the settings or make changes. Without access to the DB, vbulletin has no way to confirm credentials and allow login to admincp, correct? I could manually edit a PHP file to change the storage location if needed, yes? But how to move the attachments?

I'll take the recommendation to change hosting seriously. In the meantime I'm wondering if I should be pleading my case to the hosting service to allow access to the database so I can make the required changes.

I hate being the FNG.

[Dave]

Unfortunately access to the AdminCP is required in order to do this. Just ask the host to temporarily allow you to use the site so you can take a look and fix it.

If they absolutely do not want to give you access to your own site until your database size is reduced, backup all your databases/files and move whenever you can. It's a bit of a tedious process but will but worth it.

[EagleMark]

Thank you, Dave.