问MYSQL备份脚本在windows调度程序中调度

EN

@echo off
set current=%date:~10,4%%date:~4,2%%date:~7,2%
set filename="G:\MYSQL_Backup\Paintrax-DBs-%current%.sql"
::set filename2="G:\MYSQL_Backup\Paintrax-DBs-%current%.zip"
echo %filename%
cd "G:\MYSQL_Backup"
:: mysqldump -u root -p password --all-databases > G:\MYSQL_Backup\all_databases_2022_Dec.sql
:: mysqldump -u root -p password -port 9119 --all-databases > G:\MYSQL_Backup\all_databases_20200424.sql
"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqldump.exe" --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --host=localhost --port=9119 -p password --result-file=%filename% --default-character-set=utf8 --user=root --protocol=tcp --routines --events --single-transaction=TRUE --add-drop-table --all-databases >logfile.txt
echo backup-finished
:: comment out
::if exist %filename% (
  ::  "C:\Program Files\7-Zip\7z.exe" a %filename2% %filename%
    ::echo zip-finished
::    del %filename%
::)
::if exist %filename2% (
  ::  copy %filename2% "\\x.x.x.x\MySQL Backups"
    ::echo copy-finished
::)