vBulletin Mods

The Official vBulletin Modifications Site

Moving attachments from db to fs problem
by chikuru
18 Nov 2017 03:09

I just moved the attachments from database to file system, and the database size is still big. It didnt reduce the database size.

How can I remove attachments from database?
I already tried clearing filedata table
update filedata set filedata='';

Dave 18 Nov 2017 03:42

In the AdminCP -> Maintenance > Repair / Optimize Tables > check all tables > run.
That should work.

chikuru 18 Nov 2017 03:49

Thanks for your reply Dave. I did that and its been a day and the page is still loading. Is that normal? Whats the specific tables that I need to repair/opitimize related to the attachments?

database size with attachments is 2.3GB

Dave 18 Nov 2017 03:55

It's possible it timed out and the page no longer does anything.
You can also just execute it through SSH: https://duntuk.com/how-optimize-and-...ases-using-ssh

All times are GMT. The time now is 04:57.

Powered by vBulletin® Version 3.8.14
Copyright © 2021, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.