再写一个脚本windows mysql自动备份脚本7天的脚本的程序
时间: 2023-05-26 10:04:31 浏览: 49
@echo off
setlocal enableextensions
set MYSQL_PATH="C:\Program Files\MySQL\MySQL Server 5.7\bin\"
set BACKUP_PATH="C:\mysql\backup"
set MYSQL_HOST=localhost
set MYSQL_PORT=3306
set MYSQL_USERNAME=root
set MYSQL_PASSWORD=password
rem Creates backup directory if it does not exist
if not exist %BACKUP_PATH% mkdir %BACKUP_PATH%
rem Deletes backups older than 7 days
forfiles /p %BACKUP_PATH% /s /m *.* /d -7 /c "cmd /c del @path"
rem Executes backup
for /f "tokens=1-3 delims=/" %%d in ("%date%") do (
set today=%%f-%%e-%%g
)
set now=%time:~0,2%%time:~3,2%%time:~6,2%
set backupfile=%BACKUP_PATH%\backup_%today%_%now%.sql
"%MYSQL_PATH%\mysqldump.exe" -h %MYSQL_HOST% -P %MYSQL_PORT% -u %MYSQL_USERNAME% -p%MYSQL_PASSWORD% --all-databases > "%backupfile%"
rem Shows success message
echo Backup completed successfully: %backupfile%
pause
exit
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)