folmert

cd C:\LOCALHOST\SQL_BACKUP

@echo off
For /f "tokens=2-4 delims=/ " %%a in ('date /t') do (set mydate=%%c-%%a-%%b)
For /f "tokens=1-2 delims=/:" %%a in ("%TIME%") do (set mytime=%%a-%%b)

mysqldump -u root --all-databases > %mydate%.sql

7z a -tzip %mydate%_%mytime%.zip %mydate%.sql