@ECHO OFF

set TIMESTAMP=%DATE:~10,4%%DATE:~4,2%%DATE:~7,2%

REM Export all databases into file e:\backup\databases.[year][month][day].sql
"C:\program files\mysql\mysql server 5.6\bin\mysqldump.exe" lithandb result-file="e:\backup\databases.%TIMESTAMP%.sql" --user=root --password=test123

REM Change working directory to the location of the DB dump file.
C:
CD e:\backup\

REM Compress DB dump file into CAB file (use "EXPAND file.cab" to decompress).
MAKECAB "databases.%TIMESTAMP%.sql" "databases.%TIMESTAMP%.sql.cab"

REM Delete uncompressed DB dump file.
DEL /q /f "databases.%TIMESTAMP%.sql"