The database backup sizes listed in the Site Backup & Restore tool appear different after exported.
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.
Recommended Help Content
Site Backup & Restore tool displays unexpected dates. (updated 1424 days ago)
How do I create a MySQL backup? (updated 370 days ago)
How to export your database in phpMyAdmin.. (updated 838 days ago)
Related Help Content
How do I import a backup of my database (.sql file) using phpMyAdmin? (updated 6 days ago)
I would like to dump the Table Structure for my MySQL Database, but none of the data. (updated 2019 days ago)
tags: mysql ssh
I need to Export or Import a MySQL database (updated 608 days ago)
This article will instruct you how to export a database from the command line (SSH). (updated 609 days ago)
How to backup all of your MySQL databases using the Site Backup & Restore tool (updated 1366 days ago)
How to restore MySQL databases using the Site Backup & Restore tool (updated 1005 days ago)
How to restore MySQL databases using the Site Backup & Restore tool (updated 1231 days ago)
How do I make my MySQL database compatible with the version you provide? (updated 2035 days ago)