（1）数据库默认都安装在D盘，目录为D:\mysql5.5\mysql，不要修改目录层级和文件名称，包括字母大小写，否则无法自动备份
（2）在D盘下创建一个文件夹，名称为backup
（3）将数据库自动备份脚本复制在D:\backup下
backupDB.bat
具体脚本如下（直接粘贴复制在记事本中，脚本名称为：backupDB.bat）：
@echo off
set DB_NAME=db_localserver
set USER_NAME=root
set PASSWORD=kacidev
set BACKUP_DIR=D:\backup
set LOG_FILE=D:\backup\backup_%date:~0,4%-%date:~5,2%-%date:~8,2%.log
mysqldump -u%USER_NAME%-p%PASSWORD% %DB_NAME% > %BACKUP_DIR%\backup_%date:~0,4%-%date:~5,2%-%date:~8,2%.sql
move %DB_NAME%*.sql %BACKUP_DIR%
echo Backup process completed at %time% >> %LOG_FILE%