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

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.

no love :confused: ?

:surprised: meh ? anyone

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.

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

-----------

-----------

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.

-----------

-----------