@echo off

for /F "usebackq tokens=1,2 delims==" %%i in (`wmic os get LocalDateTime /VALUE 2^>NUL`) do if '.%%i.'=='.LocalDateTime.' set _today=%%j
set _today=%_today:~0,4%%_today:~4,2%%_today:~6,2%

"%ProgramFiles%\MySQL\MySQL Server 8.0\bin\mysqldump" --defaults-extra-file="%SystemDrive%\Backup\backup.ini" --host=localhost --port=3306 --protocol=tcp --default-character-set=utf8 --quote-names --order-by-primary=TRUE --skip-dump-date --skip-opt --hex-blob --no-create-db --no-create-info --add-locks --disable-keys --extended-insert --lock-all-tables --quick --log-error="%SystemDrive%\Backup\%_today%.log" --result-file="%SystemDrive%\Backup\%_today%.dmp" --force --databases dim interface log

cd "%SystemDrive%\Backup"

"%ProgramFiles%\7-Zip\7z" a "%SystemDrive%\Backup\%_today%.7z" *.dmp *.log -t7z -mx9
del /q *.dmp
del /q *.log

forfiles /p "%SystemDrive%\Backup" /s /m *.7z /c "cmd /c Del @path" /d -30

@echo on
exit