Moving attachments from db to fs problem

[chikuru]

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]

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

[chikuru]

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]

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-auto-repair-all-mysql-databases-using-ssh