@echo off
SET db = "cdcol"
SET user = "root"
SET password = ""
SET backupTime="%date:~0,2%-%date:~3,2%-%date:~6,6%_%time:~0,2%-%time:~3,2%"
@echo start dumping DB %time%, wait please...
mysqlcheck -u %user% --password="%password%" -s -r %db% > check\%backupTime%-sql_check.log
mysqldump -u %user% --password="%password%" --opt %db% > dumps\goldworld-x100_%backupTime%.sql
@echo All MySQL databases dumped ... (%time%)