Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 20 Sep 2014, 03:51
findingpeace's Avatar
findingpeace findingpeace is offline
 
Join Date: Nov 2011
Question 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!

Last edited by findingpeace; 20 Sep 2014 at 04:04.
Reply With Quote
  #2  
Old 20 Sep 2014, 04:54
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
Did you run an optimize?
__________________
Looking for ImpEx?
Reply With Quote
  #3  
Old 20 Sep 2014, 13:21
findingpeace's Avatar
findingpeace findingpeace is offline
 
Join Date: Nov 2011
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?
Reply With Quote
  #4  
Old 20 Sep 2014, 17:23
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
Yes, we still keep data in there, just not the binary data.
__________________
Looking for ImpEx?
Reply With Quote
  #5  
Old 20 Sep 2014, 18:27
findingpeace's Avatar
findingpeace findingpeace is offline
 
Join Date: Nov 2011
Thanks very much for your help!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

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

Layout Options | Width: Wide Color: