Evo naskrabao sam ti nesto sto brise x dana starije backupove i komprimuje. Za Widnows je i cisto da imas ideju kako to moze relativno prosto da se sklepa, pa skroj po tvojim potrebama.
Code:
FORFILES /P "C:\Users\User\Dropbox\SQLBackup" /M * /D -180 /C "CMD /C DEL @path"
SET dbuser=[username]
SET dbpass=[password]
SET dbname=[dbname]
"C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqldump.exe" -u %dbuser% -p%dbpass% %dbname% > "C:\Tmp\%dbname%_%date:~-4,4%%date:~-7,2%%date:~-10,2%.sql"
"C:\Program Files\7-Zip\7zG.exe" a -t7z "C:\Users\User\Dropbox\SqlBackup\%dbname%_%date:~-4,4%%date:~-7,2%%date:~-10,2%.7z" "C:\Tmp\%dbname%_%date:~-4,4%%date:~-7,2%%date:~-10,2%.sql"
DEL "C:\Tmp\%dbname%_%date:~-4,4%%date:~-7,2%%date:~-10,2%.sql"