What is mysqldump?

MySQL provides a data backup utility called mysqldump. We can use it for creating logical backup of a database. Logical backup is a set of SQL statements that can be executed to recreate the database with original object definitions and table data.

mysqldump can also be used to create database dump in csv, xml, json etc formats.