mysql数据库自动备份脚本

Author: DBA
CreateDate: 2020-09-11
:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
::  在这里指定配置参数
:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

SET MYSQL_USER="root"
SET MYSQL_PASS="111111"
SET MYSQL_HOST="localhost"
SET MYSQL_PORT="3306"
SET MYSQL_BASEDIR="C:\Program Files\MySQL\MySQL Server 5.7\bin"
SET MYSQL_DATADIR="C:\ProgramData\MySQL\MySQL Server 5.7\Data"

::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
:: begin backup(with mysql binlog) using mysqldump
Set Curr_Date=%date:~0,4%%date:~5,2%%date:~8,2%
Set Back_User=%MYSQL_USER%
Set Back_Pass=%MYSQL_PASS%
Set Back_Host=%MYSQL_HOST%
Set Back_Port=%MYSQL_PORT%
Set Back_Dest=%CronFileDest%
Set Back_Base=%MYSQL_BASEDIR%
Set Back_Data=%MYSQL_DATADIR%
Set CronFileDest=%cd%

%Back_Base%\mysqldump -u%Back_User% -p%Back_Pass% -h%Back_Host% -P%Back_Port% --all-databases --default-character-set=utf8mb4 --set-gtid-purged=OFF --flush-logs --lock-all-tables > %Back_Dest%\mysql_%Curr_Date%.dmp