1.设置bat脚本,执行数据库备份

@echo off
set DB_USER=root
set DB_PASSWORD=password
set DB_NAME=database
set BACKUP_DIR=D:\mysqlbf
set DATE=%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%
set BACKUP_FILE=%BACKUP_DIR%\%DB_NAME%_%DATE%.sql
"D:\phpstudy_pro\Extensions\MySQL5.7.26\bin\mysqldump" --quote-names -u %DB_USER% -p%DB_PASSWORD% %DB_NAME% > %BACKUP_FILE%
if %errorlevel% equ 0 (
    echo Success: %BACKUP_FILE%
pause
) else (
    echo Fail
pause
)

*第一次设置时，出现mysqldump:  “Couldn't find table” 错误

在导出命令行添加  --quote-names 解决

2.windows系统设置任务计划程序，定时执行脚本