Clean up filedata table after database -> filesystem
 

I ran the database -> filesystem change for attachments (ACP -> Attachments -> Attachment Storage Type -> Move Items from Database into File System) and everything works, but my database size is unchanged. More than 500MB should have been trimmed off, but the filedata table still shows identical from before I ran the change. I said "Yes" to the cleanup changes at the very end.

Any ideas on how I can update this table now that attachments/avatars are stored on disk?

Thanks!

Did you run an optimize?

Thanks Zachery! That did the trick - but even though the database is 500mb smaller, I still see 6,000+ rows in the filedata table, is that expected?

Yes, we still keep data in there, just not the binary data.

Thanks very much for your help!