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
mysqldump --user root --password --all-databases (graterthan sign) all-databases.sql