rem for /L %%i in (1,1,7) do echo %%i 1> %%i.sql
rem echo %%i 1>tmp.sql 创建新文件 tmp.sql
mysqldump -uroot -p123456 bxyc > tmp.sql
if exist 7.sql (
rem echo 7.sql has exist
setlocal ENABLEDELAYEDEXPANSION
del /Q 1.sql
for /L %%i in (2,1,7) do (
set /a val = %%i-1
rename %%i.sql !val!.sql
)
rename tmp.sql 7.sql
setlocal DISABLEDELAYEDEXPANSION
goto :end
)
for /L %%i in (1,1,7) do (
if not exist %%i.sql (
rem 重命名
rename tmp.sql %%i.sql
goto :end
)
)
:end
批处理备份mysql数据库
最新推荐文章于 2024-09-15 08:03:51 发布