window exe文件备份mysql数据库

cd /d D:mysql-advanced-5.6.22-winx64in>mysql    --打开数据库
set pwd=gtasecp@139
set nowtime=%date:~0,4%%date:~5,2%%date:~8,2%
mysqldump -u root --password=%pwd% gtappm >D:dbBackUp\%nowtime%gtappm.sql
mysqldump -u root --password=%pwd% gtasecp >D:dbBackUp\%nowtime%gtasecp.sql
mysqldump -u root --password=%pwd% gtasecpcms >D:dbBackUp\%nowtime%gtasecpcms.sql
mysqldump -u root --password=%pwd% gtasecpbbs >D:dbBackUp\%nowtime%gtasecpbbs.sql
mysqldump -u root --password=%pwd% rts_20141016 >D:dbBackUp\%nowtime%rts_20141016.sql

原文地址:https://www.cnblogs.com/gtaxmjld/p/4364800.html