window异地备份linux的mysql数据库

步骤1.

安装mysql

步骤2.

在安装路径下新建bakmysql.bat文件放入下面的内容：

echo ytw-produce-db backup is starting...
set filename=F:\bak\db\ytw-produce\syd_platform_mall\ytw-p-%date:~0,4%-%date:~5,2%-%date:~8,2%-%time:~0,2%-%time:~3,2%-%time:~6,2%.sql
echo %filename%
mysqldump --default-character-set=utf8 -h{ip} -u{用户名} -p{密码}@# syd_platform_mall>%filename%
echo finish backup!

步骤3.

新建windows计划任务执行bat文件

转载于:https://my.oschina.net/u/3010158/blog/1530107