How mysqldump is processing backup?
From which all files is it reads data for creating dump?
Is the process differs if storage engines are different?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
mysqldump is a client application. It connects to the MySQL server using "normal" credentials and queries for data.
It has no immediate access to the data other than what it can ask of the server. The mysqldump binary doesn't have to run on the same host as the MySQL server. Hence it is obvious it cannot access files directly.
It is instructive to turn the general log on for the duration of the dump to understand how it works.
For example, you might see in the general log queries such as:
As you can see, mysqldump interrogates the schema via
So, mysqldump's power is by correctly iterating all objects and querying for data, then producing the SQL statements to generate those.
Since mysqldump accesses as any normal client (seen by the above