Windows批处理文件备份还原数MySql据库

1）backup.bat

c:
cd C:\Program Files\MySQL\MySQL Server 8.0\bin
set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"
mysqldump -uroot -pP@ssw0rd djangodemo >>D:\backup\djangodemo_%Ymd%.sql

2）restore.bat

c:
cd C:\Program Files\MySQL\MySQL Server 8.0\bin
mysql -uroot -pP@ssw0rd
use djangodemo
source D:\backup\djangodemo_20200301.sql

如果批处理不行，就手动执行