11,848
社区成员
发帖
与我相关
我的任务
分享
echo MySQL数据库备份
echo *****************************
echo.
echo 今天是 %DATE%
echo 时间是 %TIME%
echo.
echo *****************************
SET "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"
md "E:\Backup\Mysql\%Ymd%"
"C:\MySQ\bin\mysqldump" -uroot -p123456 xx > "E:\Backup\Mysql\%Ymd%\xx_bak.sql"
"C:\MySQ\bin\mysqldump" -uroot -p123456 oo > "E:\Backup\Mysql\%Ymd%\oo_bak.sql"
"C:\MySQ\bin\mysqldump" -uroot -p123456 xxoo > "E:\Backup\Mysql\%Ymd%\xxoo_bak.sql"
........
echo.
echo MySQL数据库备份完成,请进行检查。。。
echo.
echo.
pause
@echo off
echo 现在是 %DATE% %TIME%
echo.
echo MySQL数据库备份
echo *****************************
echo.
SET "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"
md "E:\Backup\Mysql\%Ymd%"
FOR /f %i in ('F:\MySQL\bin\mysql -uroot -p123456 -N -e "show databases";') do "F:\MySQL\bin\mysqldump" -uroot -p123456 %i >"E:\Backup\Mysql\%Ymd%\%i.sql"
echo MySQL数据库备份完成,请进行检查。。。
echo.
echo.
pause