I execute the line below in the bat file or simply in cmd and it works:
mysqldump -uroot -hlocalhost -pxxx database1 > C:\backup_mysql\database1_%DATE%.sql
The output is:
database1_07-05-2020.sql
In my case it puts “-” on date, no spaces exists.
I execute the line below in the bat file or simply in cmd and it works:
mysqldump -uroot -hlocalhost -pxxx database1 > C:\backup_mysql\database1_%DATE%.sql
The output is:
database1_07-05-2020.sql
In my case it puts “-” on date, no spaces exists.