[My-sql] Windows 백업 bat 파일

백업 bat 파일 생성

 

PATH 등록 : C:\Program Files\MySQL\MySQL Server 8.0\bin

 

@ECHO OFF
ECHO MySQL backup start

FOR /F "tokens=1-3 delims=- " %%a IN ('DATE /T') DO (SET dt=%%a-%%b-%%c)
FOR /F "tokens=1-4 delims=:." %%a IN ('ECHO %TIME%') DO (SET tm=%%a%%b%%c%%d)

SET backupfilename=_%dt%_%tm%.sql
ECHO backupfilename : %backupfilename%

mysqldump --routines -h 127.0.0.1 -uadmin -ppassword sbrtls > D:\backup\db\"backup%backupfilename%"

ECHO delete old backup file
FORFILES /P D:\backup\db /S /M *.sql /D -30 /C "cmd /c del @file"
ECHO MySQL backup end