MySQL数据库远程备份

@echo off  
set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%" 

set "Hms=%time:~0,2%%time:~3,2%%time:~6,2%"
set "Hms=%Hms: =0%"
set "filePath=D:\mysql_backup"  
C:
cd C:\Program Files\MySQL\MySQL Server 5.6\bin
if not exist %filePath% (
  md %filePath%
)
mysqldump --opt -h192.168.16.3 -uroot -P3306 --password=123456 database > %filePath%\database_%Ymd%_%Hms%.sql  
@echo on 

或者：

@echo off
set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%" 

set "Hms=%time:~0,2%%time:~3,2%%time:~6,2%"
set "Hms=%Hms: =0%"
set "filePath=G:\ty_back\mysql_back"  
C:
cd C:\Program Files\MySQL\MySQL Server 5.6\bin
if not exist %filePath% (
  md %filePath%
)
mysqldump --opt -h192.168.16.3 -uroot -P3306 -p123456 database > %filePath%\database_%Ymd%_%Hms%.sql  
CMD

备注：

filePath：备份文件路径

C:\Program Files\MySQL\MySQL Server 5.6\bin：MySQL服务路径

-h192.168.16.3：远程数据库IP

database:数据库名

远程连接数据库不成功:

修改mysql数据库里面的user表的127.0.0.1为%

再执行下面语句刷新权限（或者重启MySQL服务）

 FLUSH PRIVILEGES 

远程用于就可以登录了