How to backup MySQL database on Windows or Mac - Terminal, Command-line

When installing a MySQL server, the main backup utility is automatically installed – mysqldump. This command-line utility creates a backup file with a set of commands to recreate the database.

To create a backup of all MySQL server databases, run the following command:
-----------------------------------------------------------------------------------------------------
1- Fetch single Database
mysql --user root --password [db_name] (graterthan sign) [db_name].sql
2- Fetch all dabase