Simpan text diantara garis sama dengan dg format bat

 =====================================================================

rem credentials to connect to mysql server

set mysql_user=root

set mysql_password=

set database=labkesda

rem archive password

rem set encryption_password=***********

rem Credentials to connect to network folder

rem set network_folder=\\192.168.1.1\Elements

rem set network_user=192.168.1.1\kevin

rem set network_password=***********

rem backup storage period (in days)

rem set max_keep_days=1

rem path to backup compression utility

set seven_zip_path=C:\Program Files\7-Zip\

rem path to backup 

set seven_zip_path=D:\Dolanan\

rem backup file name generation

set backup_name=%database%%DATE:~-4%%DATE:~-7,2%%DATE:~-10,2%

rem set backup_name=%database%

rem backup creation

rem mysqldump --user=%mysql_user% --password=%mysql_password% --all-databases >> %backup_name%.sql

C:\xampp\mysql\bin\mysqldump --user=%mysql_user% --password=%mysql_password% %database% >> %backup_name%.sql

if %ERRORLEVEL% neq 0 eventcreate /ID 1 /L APPLICATION /T ERROR /SO mysql-backup-script /D "Backup failed: error during dump creation" && exit


rem backup compression

rem "%seven_zip_path%7z" a -p%encryption_password% %backup_name%.zip %backup_name%.sql

"%seven_zip_path%7z" a E:\%backup_name%.zip %backup_name%.sql

if %ERRORLEVEL% neq 0 eventcreate /ID 1 /L APPLICATION /T ERROR /SO mysql-backup-script /D " Backup failed: error during archive creation" && exit


rem delete temporary .sql file

del %backup_name%.sql


rem create temporary network drive for file transfer

rem net use N: %network_folder% /u:%network_user% %network_password%

rem copy backup to sorage

rem robocopy %backup_name%.zip "N:\" /e /maxage:3

rem if %ERRORLEVEL% neq 0 eventcreate /ID 1 /L APPLICATION /T ERROR /SO mysql-backup-script /D "Backup failed: error during file transfer to storage" && exit

rem obsolete files from storage

rem ForFiles /p "N:\" /s /d -04 /c "cmd /c del @path & echo Deleted old: @path"

rem disconnect network drive


rem net use N: /delete

rem local backup copy


rem del %backup_name%.zip

eventcreate /ID 1 /L APPLICATION /T INFORMATION /SO mysql-backup-script /D "Backup successful" 

 =====================================================================

settinggannya bisa kalian pahami sendiri

lalu tambah task scheduler