备份数据库.bat
@setlocal enabledelayedexpansion
@echo off
color f0
title 备份数据库
rem 下面为自定义参数可修改
set mysqlServiceName=MySQL4506
set mysqlPort=4506
set rootUser=root
set rootPwd=test1
set ip=localhost
set databases=test
@REM --all-databases
set backFileName=familyxiao_rbac
rem 下面为系统设置
set basedir=%~dp0
set bin=%~dp0\bin
cd /d %~dp0
set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"
set backF=%basedir%\AutoBackup
IF EXIST %backF% (
echo %backF% 目录存在
) else (
md %backF%
)
%bin%\mysqldump -h %ip% --port %mysqlPort% --opt -u %rootUser% --password=%rootPwd% %databases% > %backF%\%backFileName%_%Ymd%.sql
:end
pause
@echo on
还原数据库.bat
@setlocal enabledelayedexpansion
@echo off
color f0
title 还原数据库
rem 下面为自定义参数可修改
set mysqlServiceName=MySQL4506
set mysqlPort=4506
set rootUser=root
set rootPwd=test1
set ip=localhost
set databases=test
@REM --all-databases
set backFileAllName=familyxiao_rbac_20220319
rem 下面为系统设置
set basedir=%~dp0
set bin=%~dp0\bin
cd /d %~dp0
set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"
set backF=%basedir%\AutoBackup
IF EXIST %backF% (
echo %backF% 目录存在
) else (
md %backF%
)
%bin%\mysql -h %ip% --port %mysqlPort% -u %rootUser% --password=%rootPwd% %databases% < %backF%\%backFileAllName%.sql
:end
pause
@echo on