Exported to filesystem, reimported to DB, now SQL..

[b00k]

is still bloated.

Basically this is what happened.

We had originally exported file attachments into the file system. All was working perfect when one of the other admins went into Attachment Storage Type and move the files back into the DB. Now, the site the attachment area says:

Attachments are currently being stored in the filesystem at /home/xxxx/public_html/sitename/attachments

Action
Move Items from File System into Database
Move Items to a Different Directory

Its odd, should i recreate a new directory for the files and re-export? It doesnt seem like the attachment table is growing when i add to the site, but the sql DB is still 400MB +

Please advise of the best solution.

[b00k]

no love :confused: ?

[b00k]

:surprised: meh ? anyone

[Paul M]

If the ACP says they are being stored in the file system then that's where they are going. The database will not shrink until you run an optimise on the attachments table.

[b00k]

...............

[b00k]

-----------

[b00k]

-----------

[Paul M]

Run this sql > DELETE FROM attachements , then optimise the table.

Seems you didn't fully complete the migration from database to file system as the table wasn't emptied.

[b00k]

-----------

[b00k]

-----------

[b00k]

-----------

[Paul M]

I doubt anyone can help you without access to your forum and server as what you report makes no sense. If the attachments are being stored in the file system (as per "Attachments are currently being stored in the filesystem at /home/xxxxx/public_html/xxxxx/attachments") then clearing out the database cannot nuke them, that suggests your forum was actually using the database, which conflicts with the message above. The only answer is for someone who understands the system to look and see what is actually happening.

[b00k]

-----------