Compress file using 7z. Generate file name using current date.
@echo off set sourceDir=C:\mysql\mysqldump set targetDir="C:\mysql\mysql-backup" @echo on 7z a %targetDir%\backup-%date:~-7,2%.7z %sourceDir%\backup-%date:~-7,2%.sql @echo off