Announcement

Collapse
No announcement yet.

After Attachments put to Fileserver Filedata Table is not cleared

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • After Attachments put to Fileserver Filedata Table is not cleared

    I removed Attachments from Database to Filesystem.
    When i look at the Datebase Filedate is as big as 11,5gb as before.

    Should it not be get smaller..?

    Best regards, Olker

  • #2
    If you did the finalization step, the contents of the filedata field will be marked as deleted. MySQL doesn't actually delete the data immediately and will do it during housekeeping tasks. Or you can run an Optimize command on the table to speed things up.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API - Full / Mobile
    Vote for your favorite feature requests and the bugs you want to see fixed.

    Comment


    • #3
      I could not do the finalization step.
      I have run cleanup and cleanup2; optimized the filedata table. It`s size is 11,2gb after optimization. But no further decrease.

      What else can i do..?

      Comment


      • #4
        Why couldn't you run the finalization from moving the files from the database to the filesystem? That is the only function that deletes the filedata from the database.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API - Full / Mobile
        Vote for your favorite feature requests and the bugs you want to see fixed.

        Comment


        • #5
          Because i was not able to do it. A blank page in the Admin-CP was the result. But the Attachments are correctly shown in the Admin-CP and the files are correctly saved.
          Can i re-run the function..?

          Or what can i else do..?

          Comment


          • #6
            If your attachments are working correctly, you can delete the filedata manually.

            update filedata set filedata='';

            Don't change the content of any other field. I recommend creating a backup of your database before you do this. You can usually do this in the database tools that your hosting provider gives you.
            Translations provided by Google.

            Wayne Luke
            The Rabid Badger - a vBulletin Cloud demonstration site.
            vBulletin 5 API - Full / Mobile
            Vote for your favorite feature requests and the bugs you want to see fixed.

            Comment


            • #7
              Thanx.

              It worked

              Comment

              Related Topics

              Collapse

              Working...
              X