mysql远程备份

 

可放入TOMCAT的启动startup.bat文件内，启动tomcat 时备份数据库

或

新建backup.bat，手动备份

 

设置mysqldump全局环境变量或使用时写入绝对路径

 

@echo off
set date0=%date:~0,10%
set time0=%time:~0,8%
set time1=%time:~0,2%
set time2=%time:~3,2%
set time3=%time:~6,2%
echo %time0%
echo %time1%
echo %time2%
echo %time3%
mysqldump -ugsm -pgsm -h 192.168.1.20 heli > "c:\heli %date0% %time1% %time2% %time3%.sql"

mysqldump -u<用户> -p<密码> -h <ip> <database> > "路径文件.sql"