mysql自动备份
1. mysql日常备份批处理命令
@echo off
set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"
d:
cd D:\Program Files\mysql\mysql-8.0.15-winx64\bin
mysqldump --opt -u root --password=555 db>D:\mysql_Backup\db_%Ymd%.sql
@echo on
2.windows计划任务程序
mysql自动备份
1. mysql日常备份批处理命令
@echo off
set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"
d:
cd D:\Program Files\mysql\mysql-8.0.15-winx64\bin
mysqldump --opt -u root --password=555 db>D:\mysql_Backup\db_%Ymd%.sql
@echo on
2.windows计划任务程序