buccp

@echo off

for /f "tokens=1-4 delims=/ " %%i in ('date /t') DO (
    set DAY=%%i
    set MONTH=%%j
    set YEAR=%%k
)

set DST_SERVER="x.x.x.x"
set DST_PORT="yyyy"
set DST_USER="zzzz"
set DST_PASS="zzzz"
set BIN_7ZIP="C:\Program Files\7-Zip\7z.exe"
set BIN_MYSQL="C:\xampp\mysql\bin\mysqldump.exe"
set BACKUP_PATH="C:\Users\PABX PC\Desktop\itccp-%YEAR%%MONTH%%DAY%"

%BIN_MYSQL% -P %DST_PORT% -h %DST_SERVER% -u %DST_USER% -p%DST_PASS% --all-databases > %BACKUP_PATH%.sql

%BIN_7ZIP% a "itccp-%YEAR%%MONTH%%DAY%.xz" %BACKUP_PATH%.sql

move "itccp-%YEAR%%MONTH%%DAY%.xz" %BACKUP_PATH%.xz