@ECHO off
echo Updating ban system...
mysql --user="backup" --password="censored" -e "DELETE FROM minecraft_update.`ban_system` WHERE `length` = '1'"
mysql --user="backup" --password="censored" -e "UPDATE minecraft_update.`ban_system` SET `length` = `length` - '1' WHERE `length` <> '0'"

echo Backing up zzworld...
set DATET=%date:~-4%_%date:~7,2%
"c:\program files\mysql\MySQL Server 5.5\bin\mysqldump" --host="127.0.0.1" --user="backup" --password="censored" zzworld > "c:\users\root\desktop\Back Up System\backups\"backup_%DATET%_zzworld.sql
echo Done.
echo Backing up zzzworld...
set DATET=%date:~-4%_%date:~7,2%
"c:\program files\mysql\MySQL Server 5.5\bin\mysqldump" --host="127.0.0.1" --user="backup" --password="censored" zzzworld > "c:\users\root\desktop\Back Up System\backups\"backup_%DATET%_zzzworld.sql
echo Done.
echo Backing up zzchar...
"c:\program files\mysql\MySQL Server 5.5\bin\mysqldump" --host="127.0.0.1" --user="backup" --password="censored" zzchar > "c:\users\root\desktop\Back Up System\backups\"backup_%DATET%_zzchar.sql
echo Done.
echo Backing up zzlogon...
"c:\program files\mysql\MySQL Server 5.5\bin\mysqldump" --host="127.0.0.1" --user="backup" --password="censored" zzlogon > "c:\users\root\desktop\Back Up System\backups\"backup_%DATET%_zzlogon.sql
echo Done.
echo Backing up authme...
"c:\program files\mysql\MySQL Server 5.5\bin\mysqldump" --host="127.0.0.1" --user="backup" --password="censored" authme > "c:\users\root\desktop\Back Up System\backups\"backup_%DATET%_authme.sql
echo Done.
echo Backing up zchar...
"c:\program files\mysql\MySQL Server 5.5\bin\mysqldump" --host="127.0.0.1" --user="backup" --password="censored" zchar > "c:\users\root\desktop\Back Up System\backups\"backup_%DATET%_zchar.sql
echo Done.
echo Backing up minecraft_update...
"c:\program files\mysql\MySQL Server 5.5\bin\mysqldump" --host="127.0.0.1" --user="backup" --password="censored" minecraft_update > "c:\users\root\desktop\Back Up System\backups\"backup_%DATET%_minecraft.sql
echo Done.
echo Backing up donations...
"c:\program files\mysql\MySQL Server 5.5\bin\mysqldump" --host="127.0.0.1" --user="backup" --password="censored" donations > "c:\users\root\desktop\Back Up System\backups\"backup_%DATET%_donations.sql
echo Done.
echo Backing up spencer2...
"c:\program files\mysql\MySQL Server 5.5\bin\mysqldump" --host="127.0.0.1" --user="backup" --password="censored" spencer2 > "c:\users\root\desktop\Back Up System\backups\"backup_%DATET%_spencer2.sql
echo Done.
echo Backing up maruum world...
"c:\program files\mysql\MySQL Server 5.5\bin\mysqldump" --host="127.0.0.1" --user="backup" --password="censored" mc_world > "c:\users\root\desktop\Back Up System\backups\"backup_%DATET%_mc_world.sql
echo Done.
echo Backing up maruum char...
"c:\program files\mysql\MySQL Server 5.5\bin\mysqldump" --host="127.0.0.1" --user="backup" --password="censored" mc_char > "c:\users\root\desktop\Back Up System\backups\"backup_%DATET%_mc_char.sql
echo Done.
echo Backing up maruum logon...
"c:\program files\mysql\MySQL Server 5.5\bin\mysqldump" --host="127.0.0.1" --user="backup" --password="censored" mc_logon > "c:\users\root\desktop\Back Up System\backups\"backup_%DATET%_mc_logon.sql
echo Done.
echo Compressing...

"C:\users\root\desktop\Back Up System\7za" a -tzip "C:\users\root\desktop\Back Up System\"backup_%DATET%_DBs.zip "C:\users\root\desktop\Back Up System\Backups"
xcopy "C:\users\root\desktop\Back Up System\"backup_%DATET%_DBs.zip "C:\users\wow\desktop\wow dev\scripts\dropbox\db_backup"

echo Done.
echo Deleting old files...

del "C:\users\root\desktop\Back Up System\Backups\*.sql"
del "C:\users\root\desktop\Back Up System\backup_%DATET%_DBs.zip"

echo Done!