通过共享目录异地备份（文件增量/数据库全量）

1.在目标计算机上：
新建用户username
将共享文件夹dir设置共享，赋权限给username
将共享文件夹dir属性安全中，赋权限给username

2.源计算机上新建backup.bat，内容如下
@echo off
echo %date% %time%
net use z: \\dest host\dir password /user:username
echo backup news database ...
C:
cd C:\Program Files\MySQL\MySQL Server 5.0\bin\
mysqldump -u root --password={password} dbname > z:\database\news%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%.dat
echo copying news files ...
xcopy E:\wwwroot\news\. z:\news_backup\news\ /S /D /C /Y /Q /R
xcopy E:\news_upload\. z:\news_backup\news_upload\ /S /D /C /Y /Q /R
net use z: /delete
@echo on

3.源计算机创建任务计划运行backup.bat