Backup MySQL (script) under Window platform

@echo off

Echo-------------------------

echo MySQL Backup

Echo 2014.11.26

Echo-------------------------

Set Jtkd_d=jtkd_d_%date:~0,4%%date:~5,2%%date:~8,2%.sql

Set Jtkd_accountdb=jtkd_accountdb_%date:~0,4%%date:~5,2%%date:~8,2%.sql

Set Jtkd_static=jtkd_static_%date:~0,4%%date:~5,2%%date:~8,2%.sql

Set Jtkd_statistics=jtkd_statistics_%date:~0,4%%date:~5,2%%date:~8,2%.sql

CD D:\Program files\mysql\mysql Server 5.5\bin

Mysqldump-uroot-proot--databases jtkd--routines--events--triggers >d:\backup\%jtkd_d%

CD \

CD bat

@echo off

REM Pause

This article is from the "SQL Server MySQL" blog, so be sure to keep this source http://dwchaoyue.blog.51cto.com/2826417/1582742

Backup MySQL (script) under Window platform