The Arcive of vBulletin Modifications Site.

mtlcore · #1 08-15-2007, 02:08 AM

Recently I deleted all the attachments without deleting the threads as posted by a senior member on this forum.

Now, I had 700mb database before that and still do after deleting them. Why is that?

Eikinskjaldi · #2 08-15-2007, 02:59 AM

Are your attachments perchance on the file system instead of in the database?

mtlcore · #3 08-15-2007, 03:31 AM

Nope: Attachments are currently being stored in the database

Lynne · #4 08-15-2007, 12:37 PM

Did you repair/optimize the attachment table after deleting them? Also, what is the method you used to delete all those attachments?

mtlcore · #5 08-15-2007, 03:15 PM

Quote:

Originally Posted by Lynne

Did you repair/optimize the attachment table after deleting them? Also, what is the method you used to delete all those attachments?

I didn't do that. Will that remove them from the database?

I first soft-deleted the threads (so that attachments were removed) then I just restored the threads, that way the threads were there but the attachments were gone.

ssslippy · #6 08-15-2007, 06:33 PM

That is not how u remove attachments, all you did was remove them from the post.

Lynne · #7 08-16-2007, 01:08 PM

Quote:

Originally Posted by ssslippy

That is not how u remove attachments, all you did was remove them from the post.

Yeah, I think all you did was 'hide' them. I've never had to deal with that problem, but I *think* you just need to go to Admin CP > Attachments > Search and search for all hidden attachments and then delete them. I think if I were to try that, I would back-up my database, put it on my test forum, and try it there first since I have never done it before and would worry about the consequences if I were wrong.

mtlcore · #8 08-17-2007, 02:37 PM

Ok, I did the optimize tables and it got rid of the attachments

. Almost 500MB!! Thanks!