求win系统里能自动备份mysql的工具小软件

moe

3年前

谢谢

铜球

navicat for mysql。
软件里有一个叫做“计划”的按钮，可以添加备份数据库的计划任务

%1 mshta vbscript:createobject("wscript.shell").run("""%~0"" rem",0)(window.close)&&exit
@echo off

set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"
set "hh=%time:~0,2%"
if /i %hh% LSS 10 (set hh=0%time:~1,1%)
set "mm=%time:~3,2%"
set "Ymdhm=%Ymd%%hh%%mm%"

set "bak_path=D:beifensql"
set "mysql_dump_path=C:Program FilesMySQLmysql-5.7.16-winx64bin"

"C:Program FilesMySQLmysql-5.7.16-winx64binmysqldump.exe" -h IP -P9001 -uroot -p"PWD" –default-character-set=utf8 v3_new > %bak_path%v3_new_%Ymdhm%.sql
"C:Program FilesMySQLmysql-5.7.16-winx64binmysqldump.exe" -h IP -P9001 -uroot -p"PWD" –default-character-set=utf8 create_db > %bak_path%create_db_%Ymdhm%.sql
forfiles /p D:beifensql /m *.sql -d -30 /C "cmd /c del /f @path" 2>>D:beifensqllog.txt

Tuzi 发表于 2022-1-12 10:34
%1 mshta vbscript:createobject("wscript.shell").run("""%~0"" rem",0)(window.close)&&exit
@echo off
…

自己改改放到 bat 里然后再添加到计划任务里

自己写脚本