• 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

RichardKYA

Well-known member
#1
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 :)
 

RichardKYA

Well-known member
#3
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
 

wang

Well-known member
#4
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.
 

RichardKYA

Well-known member
#5
Yes, very strange indeed, having a deeper look, everything looks the same apart from the size. I'll just truncate the table

Thank you
 

Brogan

XenForo moderator
Staff member
#6
There are ~ three times as many records in the imported table.

Did you run any rebuilds after importing?
 

RichardKYA

Well-known member
#7
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.