1.数据库的确有文件
2.数据库备份语句:
@echo off
set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"
"C:\Program Files\MySQL\MySQL Server 8.0\bin"\mysqldump --defaults-extra-file=my.ini-uroot -proot weibo> E:\spider\db_%Ymd%.sql
@echo on
3.最终结果:
1.数据库的确有文件
2.数据库备份语句:
@echo off
set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"
"C:\Program Files\MySQL\MySQL Server 8.0\bin"\mysqldump --defaults-extra-file=my.ini-uroot -proot weibo> E:\spider\db_%Ymd%.sql
@echo on
3.最终结果:
是"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqldump" 吧