If you ever made backups from command line, you’d probably wanted to do this on a regular basis, including date and time of your backup (e.g. to keep backups for a week or so). Here is a simple command, that will allow you to do this:
mysqldump -h host -u user -p password database_name > backup_$(date "+%b-%d-%Y-%H-%M-%S").sql |
You can specify your own format by adding or removing date parameters. This command will give you something like Feb-24-2016-12-12-13.
source : https://www.lampdocs.com/how-to-add-date-and-time-into-database-backup-file-name-in-mysqldump/