XF 1.5 Imported database increased in size


Well-known member

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 :)


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


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.


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


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

Did you run any rebuilds after importing?


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.