Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 18 Nov 2017, 02:09
chikuru chikuru is offline
 
Join Date: Nov 2011
Moving attachments from db to fs problem

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='';
Reply With Quote
  #2  
Old 18 Nov 2017, 02:42
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
In the AdminCP -> Maintenance > Repair / Optimize Tables > check all tables > run.
That should work.
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #3  
Old 18 Nov 2017, 02:49
chikuru chikuru is offline
 
Join Date: Nov 2011
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
Reply With Quote
  #4  
Old 18 Nov 2017, 02:55
Dave Dave is offline
 
Join Date: Jun 2010
Real name: 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-...ases-using-ssh
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
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 01:42.

Layout Options | Width: Wide Color: