mysql 备份数据库

时间:2018-10-28 08:54:46
【文件属性】:

文件名称:mysql 备份数据库

文件大小:298B

文件格式:BAT

更新时间:2018-10-28 08:54:46

mysql 备份数据库

@echo off if not exist d:\DBBackup md d:\DBBackup set bak_db=zzs set host_db=192.168.58.133 set h=%time:~0,2% set h=%h: =0% set bak_time=%date:~0,4%%date:~5,2%%date:~8,2%%h%%time:~3,2%%time:~6,2% mysqldump -h %host_db% -uroot -pp@ssw0rd %bak_db% > D:\DBBackup\%bak_db%_%bak_time%.sql


网友评论