mysqldump备份数据库脚本

##windows

rem ******MySQL backup start********
@echo off

set dbA=testdb
set dbB=testdbmap
set dbC=testdbmapbck

set user=bakuser
set passwd=passwd
set host=10.xx.xx.xx
set path=D:\mysqlbackup\testdb
set Port=13306
set mysqldump=D:\mysqlclient\mysql-5.7.40-winx64\bin\mysqldump

set "date_time=%date:~0,4%%date:~5,2%%date:~8,2%0%time:~1,1%%time:~3,2%%time:~6,2%"

::%mysqldump% -u%user% -p%passwd% -P%Port% -h%host% testdb > %path%\backup_%dbA%_%date_time%.sql
%mysqldump% -u%user% -p%passwd% -P%Port% -h%host% --ignore-table=testdb.sys_log --ignore-table=testdb.d_interface_log --ignore-table=testdb.imf_msg_log_202406 --ignore-table=testdb.flt_msg_log_202306  testdb > %path%\backup_%dbA%_%date_time%.sql
%mysqldump% -u%user% -p%passwd% -P%Port% -h%host% testdbmap > %path%\backup_%dbB%_%date_time%.sql
%mysqldump% -u%user% -p%passwd% -P%Port% -h%host% testdbmapbck > %path%\backup_%dbC%_%date_time%.sql

rem ******zip backup start********
c:
cd c:\
cd c:\"Program Files"\7-Zip
7z.exe a %path%\backup_%dbA%_%date_time%.zip %path%\backup_%dbA%_%date_time%.sql
7z.exe a %path%\backup_%dbB%_%date_time%.zip %path%\backup_%dbB%_%date_time%.sql
7z.exe a %path%\backup_%dbC%_%date_time%.zip %path%\backup_%dbC%_%date_time%.sql


rem ******del sql_backup_file start********
del %path%\backup_%dbA%_%date_time%.sql
del %path%\backup_%dbB%_%date_time%.sql
del %path%\backup_%dbC%_%date_time%.sql

forfiles /p "D:\mysqlbackup\testdb" /s /m "backup*.zip" /d -7 /c "cmd /c del @path"

@echo on
rem ******MySQL backup end********
exit 0