备份和还原mysql数据库bat脚本如何写,navicat连接名为tt,数据库名为tt.登录名为root 密码为空。SET backupdir=d:\myBackup
SET mysqldir="C:\Program Files\MySQL\MySQL Server 5.1"
SET dbname=mytest
SET dbuser=root
SET dbpasswd=
SET filename="tt.sql"
@ECHO Beginning backup of %dbname%... mysqldump -u %dbuser% -p%dbpasswd% %dbname% >d:\myBackup\%filename%
@ECHO Done!
这么写备份的sql文件是空的。
SET mysqldir="C:\Program Files\MySQL\MySQL Server 5.1"
SET dbname=mytest
SET dbuser=root
SET dbpasswd=
SET filename="tt.sql"
@ECHO Beginning backup of %dbname%... mysqldump -u %dbuser% -p%dbpasswd% %dbname% >d:\myBackup\%filename%
@ECHO Done!
这么写备份的sql文件是空的。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货