Database backup script for WIN

[Thatgun]

Add this to <any file>.bat


set YYYYMMDD=%DATE:~10,4%%DATE:~4,2%%DATE:~7,2%
set auth_YYYYMMDD=%DATE:~10,4%%DATE:~4,2%%DATE:~7,2%
set characters_YYYYMMDD=%DATE:~10,4%%DATE:~4,2%%DATE:~7,2%
set world_YYYYMMDD=%DATE:~10,4%%DATE:~4,2%%DATE:~7,2%
set hotfixes_YYYYMMDD=%DATE:~10,4%%DATE:~4,2%%DATE:~7,2%

rem C:\>echo %YYYYMMDD%
rem "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqldump.exe" -uroot -pacore acore_auth > "C:\!_backups"\woltk_backup_%Date:~0,2%%Date:~3,2%%Date:~6,4%.sql
"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqldump.exe" -uroot -pacore auth > "C:\!_backups"\actual_auth_%auth_YYYYMMDD%.sql
"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqldump.exe" -uroot -pacore characters > "C:\!_backups"\actual_characters_%characters_YYYYMMDD%.sql
"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqldump.exe" -uroot -pacore world > "C:\!_backups"\actual_world_%world_YYYYMMDD%.sql
"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqldump.exe" -uroot -pacore hotfixes > "C:\!_backups"\actual_hotfixes_%hotfixes_YYYYMMDD%.sql

"C:\Program Files\7-Zip\7z.exe" a C:\!_backups\backup_actual_%YYYYMMDD% C:\!_backups\actual_auth_%auth_YYYYMMDD%.sql C:\!_backups\actual_characters_%characters_YYYYMMDD%.sql C:\!_backups\actual_world_%world_YYYYMMDD%.sql C:\!_backups\actual_hotfixes_%hotfixes_YYYYMMDD%.sql

del C:\!_backups\actual_auth_%auth_YYYYMMDD%.sql
del C:\!_backups\actual_characters_%characters_YYYYMMDD%.sql
del C:\!_backups\actual_world_%world_YYYYMMDD%.sql
del C:\!_backups\actual_world_%hotfixes_YYYYMMDD%.sql