vBulletin Mods

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='';

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

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

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