Moving attachment database error

[Lynne]

That's a problem with your server. It could be your wait_timeout. But, you will need to talk to your host about this. (That is the error when trying to do it with batches of 300, you may have to do much smaller batches.)

[stunod]

Ok, thanks! You were right! I did it in a batch of 10 and it moved them into my folder. But, If I wanted to do this once a month or so, can I put them in the same directory that I just did or do I put it in a different directory? Also, is this something this is ok to do once a month?

I just looked at my database and it still says that there is 69.9mb of the attachements. How, or what do I do next now that I have moved them to the directory?

Thanks,
Adam

[Lynne]

Go to Maintenance > Repair/Optimize Tables > select the Attachment table > Repair/Optimize > Go That will reduce the size of your attachment table.

You don't need to do this once a month. For now on, anytime someone uploads an attachment, it will get put into that folder.

[stunod]

Oh sweet! You differently know your stuff!

Thanks a million!
Adam

[stunod]

Sometime is takes a while for the sizes to change in the database but I have waited forever and the database size has not changed. I dont think it has grown much but, I still need it smaller. Any ideas on how to make in smaller. I looked in the ftp location that I told the attachments to go to and they are there.

Adam

--------------- Added [DATE]1242507175[/DATE] at [TIME]1242507175[/TIME] ---------------

Ok, I just tested the database "vb_attachments" and logged into the "phpmyadmin" and deleted an attachment in there and found out that it deletes it out of my forum as well. I though the images were saved in the ftp directory and will not be saved in the database anymore. I'm I missing something?

Adam

[Lynne]

The attachment table still keeps information in there about the attachment, even though the attachment itself isn't there.

Did you run a repair/optimize on the attachment table after moving them out of the database and into the files? The size of the table will not change until you do so.

[stunod]

Yes, I have done that!