@ECHO off

set year=%date:~10,4%
set month=%date:~4,2%
set day=%date:~7,2%
set DATET=%year%_%month%_%day%

echo Backing up harry_auth...
"c:\program files\mysql\MySQL Server 5.5\bin\mysqldump" --host="127.0.0.1" --user="" --password="" harry_auth > "c:\users\stoneharry\desktop\backups\"%DATET%_harry_auth.sql
echo Done.
echo Backing up harry_chars...
"c:\program files\mysql\MySQL Server 5.5\bin\mysqldump" --host="127.0.0.1" --user="" --password="" harry_chars > "c:\users\stoneharry\desktop\backups\"%DATET%_harry_chars.sql
echo Done.
echo Backing up harry_world...
"c:\program files\mysql\MySQL Server 5.5\bin\mysqldump" --host="127.0.0.1" --user="" --password="" harry_world > "c:\users\stoneharry\desktop\backups\"%DATET%_harry_world.sql
echo Done.
echo Compressing...

"C:\users\stoneharry\desktop\7za" a -tzip "C:\users\stoneharry\desktop\"%DATET%.zip "C:\users\stoneharry\desktop\Backups"
xcopy C:\users\stoneharry\desktop\%DATET%.zip "C:\users\stoneharry\desktop\server\scripts\dropbox\kronos\"

echo Done.
echo Deleting old files...

del "C:\users\stoneharry\desktop\Backups\*.sql"
del "C:\users\stoneharry\desktop\%DATET%.zip"

echo Done!