MySQL : How dump is works? [closed]

I have a 10GB database and the dump takes just a few minutes.
I want to know how the system of dump works ?
Someone can tell me ?

Answer

Database consists of data and indices. Sometimes index can be really big. If DB have a number of big indices, then data itself is only a small part of DB.

mysqldump exports only data, not the indices. When DB is restored from the dump, indices are rebuilt from the scratch. Therefore 10GB DB can produce only 2GB dump. Or even less.

Attribution
Source : Link , Question Author : AssoumaniSaïd , Answer Author : Kondybas

Leave a Comment