Why database in the second website smaller?

  • Resolved vctrstyn

    (@vctrstyn)


    5 years, 8 months ago

    Hi,
    I have a question regarding database size. I have succesfully migrate my website to a new hosting. When I checkout the Cpanel and see the database size, i saw the newly migrated website has smaller database than the original. I checked everything was good but why it has smaller database? Is it due to Mysqldump?
    Thank you!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Cory Lamle

    (@corylamleorg)

    5 years, 8 months ago

    Hey @vctrstyn,

    If you run a repair and optimize on the first table it’s most likely the tables will be much closer in size. With the new database, the tables were freshly created so they will be optimized upon creation.

    Hope that helps~

    Thread Starter vctrstyn

    (@vctrstyn)

    5 years, 8 months ago

    Hi Cory,
    Thank you for your quick response!
    Actually I didn’t run repair and optimize. Is it possible that the plugin automatically optimize the database table in the process?

    Cory Lamle

    (@corylamleorg)

    5 years, 8 months ago

    Hey @vctrstyn,

    When you create the new tables they will be optimized, to begin with, compared to the old DB which was not…

    Cheers~

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Why database in the second website smaller?’ is closed to new replies.