备份数据库.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