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.
For 2020 use below code
set TIMESTAMP=%DATE:~6,4%%DATE:~3,2%%DATE:~0,2%%
echo %TIMESTAMP%
pause
Many thanks!
Greetings I am so happy I found your site, I really found you by
accident, while I was looking on Google for something else, Nonetheless I am here
now annd would just like to say kudos for a marvelous post and
a all round thrilling blog (I also love tthe theme/design), I don’t have time to
read through it all att the minute but I hav bookmarked it and
also included your RSS feeds, soo when I have time I will
be back to readd much more, Please do keep up the fantastic job. https://www.waste-ndc.pro/community/profile/tressa79906983/