XF 1.5 Imported database increased in size

[RichardKYA]

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

 

[Paul B]

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

 

[RichardKYA]

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...



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

 

[wang]

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]

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

Thank you

 

[Paul B]

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

Did you run any rebuilds after importing?

 

[RichardKYA]

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.