Need Help ASAP

[bremereric]

Hostmonster sent me an e-mail stating that one of my database tables was over 3 gigs and they were going to suspend my site if I didn't do something to correct it. In their terms of aggreement is does state their fact. So I googled vbulletin filedata.db and found a post about using the admincp attachment and move them to a file outside your database. I did that and they got copied over into the new directory I made. It left the old ones in the database. I deleted some of the old files and then posted a new post with four attachments. It incremented the filedata.db by 4 also? I thought it would now store them in the new directory I made. I guess I missed a step.:eek:

[Lynne]

The database still needs a row to point to the file. It's just that the actual file itself is not stored in the database, but information about the attachments - size, dimensions, who owns it, etc - is still stored in the database.

[bremereric]

Why would mine still stay at the same amount of memory. And this is how I understand what you said. When I moved the attachments only the pictures went? And now when I upload pictures it goes to my new directory and only the info for the picture goes to the filedata table?

[setishock]

Have you run > update counters? Specially the one about rebuild attachments?
Might be that simple.

[bremereric]

Have you run > update counters? Specially the one about rebuild attachments?
Might be that simple.Did that and it didn't help but thanks for the suggestion.

[bremereric]

I inherited this board some I did not set it up. I still need an experts help. I moved the attachments to a new file directory or so I thought. There are jpgs in that directory that I can open. The filedata table stayed at 3.0 gb. I ran the rebuild attachments and it stayed at 3.0 gb. I checked the table and optimized the table it stayed at 3.0 gb. I am attaching some screen shots of the table maybe someone may see something I am not.

[kh99]

Did you use the choices under Attachments > Attachment Storage Type? I first tried (on a test site) changing the setting in the options. That seemed to change the setting to say they were in the file system but it didn't change the database. Then I found the Attachment Storage Type menu, moved them back to the database, then moved them to the file system. When that finished there was a screen telling me to compare two numbers to make sure all attachments were moved successfully, and if they were you next had to click on the link to delete them from the database and recover the space from the table.

[setishock]

kh99 that info needs to be put somewhere where it can be found easily by others having that problem.

[Boofo]

Where is the setting in the options?

[bremereric]

Did you use the choices under Attachments > Attachment Storage Type? I first tried (on a test site) changing the setting in the options. That seemed to change the setting to say they were in the file system but it didn't change the database. Then I found the Attachment Storage Type menu, moved them back to the database, then moved them to the file system. When that finished there was a screen telling me to compare two numbers to make sure all attachments were moved successfully, and if they were you next had to click on the link to delete them from the database and recover the space from the table.I don't know what happened the first time but I renamed the previous attachment directory folder I created and created a new one. I let it work it's majic and let it run it's course. Second time was a charm. After it removed them from the database I optimized the table just a directed and I am at 119 mb database now. :D

[bremereric]

Where is the setting in the options?Admincp > Attachments > Attachment Storage Type
Not in the options.

[Boofo]

Did you use the choices under Attachments > Attachment Storage Type? I first tried (on a test site) changing the setting in the options. That seemed to change the setting to say they were in the file system but it didn't change the database. Then I found the Attachment Storage Type menu, moved them back to the database, then moved them to the file system. When that finished there was a screen telling me to compare two numbers to make sure all attachments were moved successfully, and if they were you next had to click on the link to delete them from the database and recover the space from the table.

I know about the "Admincp > Attachments > Attachment Storage Type" setting. I was referring to what kevin stated in the quote above (the bold part).

EDIT: There is no option in the vBulletin settings for this. The only way to do it is by the "Admincp > Attachments > Attachment Storage Type" setting. I don't know what kevin is referring to but I found nothing.