批处理备份mysql脚本
批处理备份MySQL脚本是非常常用的脚本之一。当我们需要对MySQL数据库进行备份操作的时候，这个脚本可以帮助我们快速且方便地备份所有需要备份的数据。以下是一个简单的批处理备份MySQL脚本。
@echo off setlocal enabledelayedexpansion set DB_USERNAME=root set DB_PASSWORD=123456 set DB_NAME=myDatabase set BACKUP_PARENT_DIR=D:BackupsMySQL set BACKUP_TARGET_DIR=%BACKUP_PARENT_DIR%%date:~0,4%-%date:~5,2%-%date:~8,2% set BACKUP_FILENAME=%DB_NAME%_%time:~0,2%_%time:~3,2%_%time:~6,2%.sql if not exist %BACKUP_TARGET_DIR% mkdir %BACKUP_TARGET_DIR% mysqldump -u %DB_USERNAME% -p%DB_PASSWORD% %DB_NAME% >%BACKUP_TARGET_DIR%%BACKUP_FILENAME% echo Backup '%BACKUP_FILENAME%' finished.
