Take a Database Backup on Terminal
It’ simple to use mysqldump to taking a database backup on terminal:
mysqldump -uDATABASEUSERNAME -pPASSWORD database_name > database_name.sql
If you don’t want to use the password with command line:
mysqldump -uDATABASEUSERNAME -p database_name > database_name.sql
It is possible to use
mysqldump --user=DATABASEUSERNAME --password=PASSWORD database_name > database_name.sql