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
如果批处理不行,就手动执行