mysql bat恢复数据库_bat执行数据库备份还原

## 备份

~~~

@echo off

echo 数据库备份开始

set BACKUP_PATH=E:\mysqldata\bak\

set DATABASES=test

set USERNAME=root

set PASSWORD=root

set MYSQL=D:\UPUPW_NP5.6\MariaDB\bin

set YEAR=%date:~3,4%

set MONTH=%date:~8,2%

set DAY=%date:~11,2%

set ADDON=%YEAR%%MONTH%%DAY%

set BACKUP_FILE=%ADDON%.sql

"%MYSQL%\mysqldump" -u%USERNAME% -p%PASSWORD% %DATABASES% > "%BACKUP_PATH%%BACKUP_FILE%" :: 备份命令

echo 数据库备份完成

pause

~~~

## 还原

~~~

@echo off

set BACKUP_PATH=E:\mysqldata\bak\

set OK_PATH=E:\mysqldata\

set OK_NAME=wx_ok.txt

set DATABASES=test

set HOST=10.16.62.87

set USERNAME=root

set PASSWORD="%%hiK&*2*" :: 特殊字符转义要加双引号，双%会转义并脱逸为单%

set MYSQL=D:\UPUPW_NP5.6\MariaDB\bin

set YEAR=%date:~3,4%

set MONTH=%date:~8,2%

set DAY=%date:~11,2%

set ADDON=%YEAR%%MONTH%%DAY%

set BACKUP_FILE=%ADDON%.sql

set TXT_OK=wx,%ADDON%,OK

set TXT_ERR=wx,%ADDON%,ERR

if exist "%BACKUP_PATH%%BACKUP_FILE%" (echo 数据库还原开始 :: 判断备份文件是否存在

"%MYSQL%\mysql" -h%HOST% -u%USERNAME% -p%PASSWORD% %DATABASES% < %BACKUP_PATH%%BACKUP_FILE% :: 还原命令

echo %TXT_OK%>%OK_PATH%%OK_NAME% :: 字符串写入txt文件

echo 数据库还原结束) else (echo %TXT_ERR%>%OK_PATH%%OK_NAME%

echo 文件不存在)

pause

~~~