windows mysqldump備份指令碼

參考  https://blog.csdn.net/amberom/article/details/80605788

@echo off
set "dbIp=127.0.0.1"
set "dbPort=3306"
set "dbUser=xxx"
set "dbPasswd=xxx"
set "binDir=C:\Program Files\MySQL\MySQL Workbench 8.0 CE"
cd %binDir%
set "rootDir=C:\Backup\rds"
set "tFile=%rootDir%\tmp_db.txt"
set "dt=%date:~,4%%date:~5,2%%date:~8,2%_%time:~,2%%time:~3,2%%time:~6,2%"
set "tDir=%rootDir%\myyshop-supplier-mysql-01-%dt%"
echo "%tDir%"
md %tDir%
mysql -h %dbIp% -P %dbPort% -u %dbUser% -p%dbPasswd% -s -e "SELECT schema_name FROM information_schema.SCHEMATA WHERE schema_name NOT IN ('information_schema', 'innodb', 'mysql', 'performance_schema', 'tmp', 'sys')" > %tFile%
for /f "delims=" %%a in ( %tFile%) do (
  echo %%a
  mysqldump -h %dbIp% -P %dbPort% -u %dbUser% -p%dbPasswd% --skip-lock-tables --skip-triggers --column-statistics=0 --set-gtid-purged=OFF %%a > %tDir%\%%a.sql
)
@echo on