SET PATH=%PATH%;C:\xampp\mysql\bin;C:\Program Files\7-Zip

for /f "tokens=2-4 delims=/ " %%i in ('date/t') do (
      (set Dy=%%j)
      (set Mth=%%i)
      (set Yr=%%k)
)
SET TODAY=%Yr%-%Mth%-%Dy%
D:
cd C:\OSgrid\1-BACKUPS
mkdir %TODAY%
cd %TODAY%

mkdir region1
cd region1
mysqldump --user=username --password=password region1 > region1.sql
copy C:\OSgrid\regions\region1\config-include\FlotsamCache.ini .
copy C:\OSgrid\regions\region1\config-include\GridCommon.ini .
copy C:\OSgrid\regions\region1\Regions\Regions.ini .
copy C:\OSgrid\configs\opensim_master.ini .
copy C:\OSgrid\configs\region1.ini .
copy C:\OSgrid\region1.bat .
cd ..

mkdir region2
cd region2
mysqldump --user=username --password=password region2 > region2.sql
copy C:\OSgrid\regions\region2\config-include\FlotsamCache.ini .
copy C:\OSgrid\regions\region2\config-include\GridCommon.ini .
copy C:\OSgrid\regions\region2\Regions\Regions.ini .
copy C:\OSgrid\configs\opensim_master.ini .
copy C:\OSgrid\configs\region2.ini .
copy C:\OSgrid\region2.bat .
cd ..

mkdir region3
cd region3
mysqldump --user=username --password=password region3 > region3.sql
copy C:\OSgrid\regions\region3\config-include\FlotsamCache.ini .
copy C:\OSgrid\regions\region3\config-include\GridCommon.ini .
copy C:\OSgrid\regions\region3\Regions\Regions.ini .
copy C:\OSgrid\configs\opensim_master.ini .
copy C:\OSgrid\configs\region3.ini .
copy C:\OSgrid\region3.bat .
cd ..

7z a -r %TODAY%.zip %TODAY%
rm -rf %TODAY%
echo "Backup Complete"