mysqldump -u [user] -p [database_name] > [filename].sql

• Replace [user] with your username and password (if needed).
• The [database_name] is the path and filename of the database.
• The > command specifies the output.
• [filename] is the path and filename you want to save the dump file as.

To backup of an entire Database :

mysqldump --all-databases --single-transaction --quick --lock-tables=false > full-backup-$(date +%F).sql -u root -p

To include more than one database in the backup :

sudo mysqldump -u [user] -p [database_1] [database_2] [database_etc] > [filename].
sql

  Important: If you have dual SVM-on-premise Application and DB server setup. Then edit the following part of the above commands to take the backup.  

mysql -u [user] -p -h <Database Sever Name>