mysqldump script for windows (also, example of how to use YMD in output filename)

By | August 27, 2015

mysqldump-script-for-windows

mysqldump.exe --defaults-file=mysqldump.cnf --all-databases -h 192.168.1.22 > backup-%date:~6,4%-%date:~3,2%-%date:~0,2%-%time:~0,2%%time:~3,2%%time:~6,2%.sql

Produces filename like backup-2015-08-27-160938.sql