window中bat数据库备份

@echo off
echo.
echo.----------------------------------------------------------
echo.        MYSQL备份批处理---五系统数据库备份
echo.-----------------------------------------------------------
echo.
echo.

set backup_dir="D:\mysql_backups\db_backups"
set "ymd=%date:~,4%%date:~5,2%%date:~8,2%"

set database1="sg-nelda-alarm"
set database2="sg-nelda-base"
set database3="sg-nelda-environ"
set database4="sg-nelda-task"
set database5="sg-nelda-violation"
set database6="nacos-config"

C:
cd C:\Program Files\MySQL\MySQL Server 5.7\bin

echo 备份%database1%库
mysqldump -h192.168.6.51 -uroot -p123456 %database1%> %backup_dir%\%database1%_%ymd%.sql
echo 备份%database2%库
mysqldump -h192.168.6.51 -uroot -p123456 %database2%> %backup_dir%\%database2%_%ymd%.sql
echo 备份%database3%库
mysqldump -h192.168.6.51 -uroot -p123456 %database3%> %backup_dir%\%database3%_%ymd%.sql
echo 备份%database4%库
mysqldump -h192.168.6.51 -uroot -p123456 %database4%> %backup_dir%\%database4%_%ymd%.sql
echo 备份%database5%库
mysqldump -h192.168.6.51 -uroot -p123456 %database5%> %backup_dir%\%database5%_%ymd%.sql
echo 备份%database6%库
mysqldump -h192.168.6.51 -uroot -p123456 %database6%> %backup_dir%\%database6%_%ymd%.sql

echo 删除7天前的备份文件
forfiles /p %backup_dir% /s /m *.sql /c "cmd /c Del @path" /d -7

echo.备份命令完成
echo.
#pause