1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.5 Imported database increased in size

Discussion in 'XenForo Questions and Support' started by RichardKYA, Mar 17, 2016.

  1. RichardKYA

    RichardKYA Well-Known Member

    Hello,

    I have a very small xf database (147.83 MB) that I exported for my dev install and after importing it to my fresh dev db, the size is now 221.37 MB

    What would cause a 75mb increase?

    Thank you for any input :)
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Compare the table sizes of each database to determine which ones are larger.
     
  3. RichardKYA

    RichardKYA Well-Known Member

    OK, had a look and this is the xf_admin_log table side by side using split view, exported db is on the left and after import on the right...

    Screen Shot 2016-03-17 at 16.20.59.jpg

    That appears to be about 74MB increase and the rows have pretty much tripled
     
  4. wang

    wang Well-Known Member

    That table logs the action that are displayed on the Admin Log in the Admin Panel. You can truncate it.

    Strange though, why its size will increase during the import.
     
  5. RichardKYA

    RichardKYA Well-Known Member

    Yes, very strange indeed, having a deeper look, everything looks the same apart from the size. I'll just truncate the table

    Thank you
     
  6. Brogan

    Brogan XenForo Moderator Staff Member

    There are ~ three times as many records in the imported table.

    Did you run any rebuilds after importing?
     
  7. RichardKYA

    RichardKYA Well-Known Member

    The only rebuild I have done since the import was a search index rebuild while testing something out with [FS] Events add-on, but that rebuild was after I noticed the increased db size.

    Other than that, I haven't performed any rebuilds.
     

Share This Page