1、创建.bat
rem *******Start Backup***********
@echo off
set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"
set fileName1="integrated_%Ymd%"
set fileName2="integrated_test_%Ymd%"
del \\192.168.1.10\mysql_backup\\integrated_*.sql
mysqldump --opt -u root --password=**** integrated --skip-lock-tables > \\192.168.1.10\mysql_backup\%fileName1%.sql
mysqldump --opt -u root --password=**** integrated_test --skip-lock-tables > \\192.168.1.10\mysql_backup\%fileName2%.sql
@echo on
rem *******Backup Finished********
2、添加计划任务程序,在操作中选择刚才创建的bat程序。起始于(可选)一定要填写.bat所在位置的文件夹地址