使用mysql的mysqldump命令,结合windows的任务计划程序,可以实现Mysql数据的自动备份。
一、批处理文件bat的创建
@echo off
set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"
D:\mysql-5.7.23-winx64\bin\mysqldump --opt -u root --password=mima peixun > D:/db_backup/db_%Ymd%.sql
@echo on
forfiles /p "D:\db_backup" /s /m *.sql /d -5 /c "cmd /c del @path"
二、任务计划的设置
Mysql数据库的备份
No.1
Mysql定时备份数据库
@echo off
set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"
D:\mysql-5.7.23-winx64\bin\mysqldump --opt -u root --password=密码 peixun > D:/db_backup/db_%Ymd%.sql
@echo on
forfiles /p "D:\db_backup" /s /m *.sql /d -5 /c "cmd /c del @path"
No.2
将数据库复制到异地
D:\mysql-5.7.23-winx64\bin\mysqldump -u root -密码 peixun --add-drop-table | mysql -h 192.168.8.8 -u root -psa@123 peixun
https://mp.weixin.qq.com/s/1D7rrmMGJ84LwworC2FTvw
https://mp.weixin.qq.com/s/jV7izpHPJHqwzD-Y9LHj4w