Hi folks I've a doubt in mysql file dump size and db size varies.
My DB size is 238MB and same DB's dump size is 297MB. Why this large variations?. Can any one explain this?.
1
-
1dba.stackexchange.com/questions/37159/…Mitch Wheat– Mitch Wheat2014-12-29 08:51:39 +00:00Commented Dec 29, 2014 at 8:51
Add a comment
|
3 Answers
The dump file is a text file. When you turn the internal data of a DB into text, there are many expansions:
- Numbers that might be 4 bytes internally are written out as digits like
123456 - Strings have quotes around them, and special characters in the strings may be escaped
- There are commas between each column, and parentheses around the rows
Comments
When you run mysqldump, only data is dumped in SQL statements. Indexed are not copied. Indexes get rebuilt when the SQL is loaded into another server.
3 Comments
Hoja
why the size is reduced in DB ?
praveen_programmer
Generally DB's dump size less then actual DB size.
praveen_programmer
@Hoja you can read details description about your issue here.dba.stackexchange.com/questions/4582/…
For a good normalized db, db size is significantly smaller than dump file.
Because the db uses a lot of numbers, I have a db with 200 mb dump, but only 80 kb in db.
As said by Barmar, during dump, numbers are converted into characters, 1234567891 uses 1 integer for storage, or 3 bytes, but 10 bytes for the characters.
