@echo on
REM------------------------backup bugdb which is InnoDB-----------------------------
del E:\mysqlbackup\parkingclientdb_*.sql /Q
c:
cd C:\Program Files\MySQL\MySQL Server 5.6\bin
rem winxp/2003
rem set logs=%mysqlBackupPath%\logs.txt
rem set day=%date:~7,2%
rem set month=%date:~4,2%
rem set /a year=%date:~10,4%
rem win7/2008
set day=%date:~8,2%
set month=%date:~5,2%
set /a year=%date:~0,4%
set filename=parkingclientdb_%year%%month%%day%.sql
mysqldump.exe parkingclientdb -uroot -p123456 > E:/mysqlbackup/%filename%
@echo off
REM pause
REM------------------------backup bugdb which is InnoDB-----------------------------
del E:\mysqlbackup\parkingclientdb_*.sql /Q
c:
cd C:\Program Files\MySQL\MySQL Server 5.6\bin
rem winxp/2003
rem set logs=%mysqlBackupPath%\logs.txt
rem set day=%date:~7,2%
rem set month=%date:~4,2%
rem set /a year=%date:~10,4%
rem win7/2008
set day=%date:~8,2%
set month=%date:~5,2%
set /a year=%date:~0,4%
set filename=parkingclientdb_%year%%month%%day%.sql
mysqldump.exe parkingclientdb -uroot -p123456 > E:/mysqlbackup/%filename%
@echo off
REM pause