HostMonster Web Hosting Help

MySQL Database Reported Size and SQL Size Differ

Problem:

The database backup sizes listed in the Site Backup & Restore tool appear different after exported.

Solution:

MySQL is a complex relational database that can contain extremely vast amounts of information—and can also store that information in a number of different ways, for efficient querying. Because of this, when a database is “live”, it's size is typically much larger.

  • When "live", the database will be split up into a number of separate files, with control structures, coding and other information necessary for the database to operate properly.
  • When exporting to an SQL file, the structures are removed and only the database data is kept, hence the typically much smaller size.
  • Knowledgebase Article 25,694 views bookmark tags: backup database dump export mysql mysqldump size sql (updated 1542 days ago)


    Was this resource helpful?

    Did this resolve your issue?


    Please add any other comments or suggestions about this content:





    Recommended Help Content

    Site Backup & Restore tool displays unexpected dates. (updated 1542 days ago)
    Knowledgebase Article 44,523 views tags: backup database dump mysql restore sql

    How do I create a MySQL backup? (updated 488 days ago)
    Knowledgebase Article 156,664 views tags: backup database mysql

    How to export your database in phpMyAdmin.. (updated 956 days ago)
    Knowledgebase Article 67,589 views tags: database export myphpadmin

    Related Help Content

    How do I import a backup of my database (.sql file) using phpMyAdmin? (updated 124 days ago)
    Knowledgebase Article 169,279 views tags: database mysql phpmyadmin

    I would like to dump the Table Structure for my MySQL Database, but none of the data. (updated 2137 days ago)
    Knowledgebase Article 130,186 views tags: mysql ssh

    I need to Export or Import a MySQL database (updated 727 days ago)
    Knowledgebase Article 228,985 views tags: mysql phpmyadmin ssh

    This article will instruct you how to export a database from the command line (SSH). (updated 726 days ago)
    Knowledgebase Article 452,801 views tags: database mysql ssh

    How to backup all of your MySQL databases using the Site Backup & Restore tool (updated 1484 days ago)
    Knowledgebase Article 61,501 views tags: backup database mysql restore site

    How to restore MySQL databases using the Site Backup & Restore tool (updated 1123 days ago)
    Knowledgebase Article 60,313 views tags: backup database mysql restore site

    How to restore MySQL databases using the Site Backup & Restore tool (updated 1350 days ago)
    Knowledgebase Article 48,354 views tags: backup database mysql restore site

    How do I make my MySQL database compatible with the version you provide? (updated 2153 days ago)
    Knowledgebase Article 84,656 views tags: database mysql