Different database and files size

  • Resolved pautgn

    (@pautgn)


    2 years, 2 months ago

    Hi,
    After a migration with SG Migrator I can see some size differences in the database and files:

    -The NEW site database is 23Mb while the original site database is only 16Mb.
    In PHPMyAdmin I can see that tables with bigger differences are these 3:
    _options: has changed from 599 rows and 4.2Mb to 644 rows and 6.3Mb (+2.1Mb)
    _postmeta: has changed from 11,439 rows and 5,8Mb to 11,440 rows and 9,5Mb (+4Mb!).
    _posts: has changed from 837 rows and 1,6Mb to the same 837 rows but 2,5Mb (+1Mb).

    Why? How Can I solve it?

    -I made .zip of the original installation files BEFORE migrating and was about 112Mb but after the migration that original installation .zip it’s 190Mb (the new site is correct at about 112Mb). I can suppose that the SG Migrator has created some extra files inside the original installation. Are they temporary files that will be deleted automatically (when?). Or Do I need to do it manually? Because I need to migrate that website again to a different destination,… but I want to migrate the original 112Mb and not the 190Mb,…

    Regards.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Pavel Dosev

    (@pdosev)

    Hello @pautgn,

    The plugin does not add any new information to the database. It might install SG-Optimizer if it wasn’t present on the old site.

    Still, to check this in more detail, you must contact us through the Siteground support channel, where we can see the two databases and the difference between them. The forum rules do not allow any access to the website and to provide you with more information, we will need to check the database itself.

    Thread Starter pautgn

    (@pautgn)

    Hi,
    Yes, the SG Security was installed but it only added 2 new tables with minimal size.
    Ok, I’ll contact support so they can check the big size difference (+50%) of the new database.

    And about the other question regarding the size of the files in the original installation before and after the migration progress, some clarification, please? It went from 112Mb to 190Mb (a .zip of all files).

    And please confirm that SG Migrator has not done any changes to the original installation (database and files,… apart from that size difference in files that I hope are temporary files).

    Regards.

    Plugin Support Vladimir Trandev

    (@vtrandev)

    Hello @pautgn,

    The website is copied at the new destination and no changes are made to the original destination.

    However, you can also share the additional details in the mentioned support ticket and we will be glad to clarify the situation in the particular case.

    Regards,
    Vladimir

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Different database and files size’ is closed to new replies.