As the name suggests, mysqldump is used to dump one or more created databases. It performs backups for data or transfers the data from SQL Server to another. Also, it helps in producing the initial database schema by logical backups. Moreover, unlike triggers, mysqldump does not backup the stored procedures or functions by default.
Syntaxes
For a single database:
mysqldump [options] db_name [tables]
For multiple databases:
mysqldump [options] –databases db1 [db2 db3...]
For all databases:
mysqldump [options] –all-databases