请问windows下mysql自动备份问题 请问windows下如何实现mysql的自动备份 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 写一个备份的脚本内容类似下边这样mysqldump -uroot -p123 dbname>dbname.sql存成BAT文件放到WINDOWS的计划任务中去执行 新建db_back.vbs,写入下列代码Dim fName,tNow,CMDtNow = Now()fName = Year(tNow) & FormatNumber(Month(tNow)/100,2,false) & FormatNumber(Day(tNow)/100,2,false) & FormatDateTime(tNow,3)fName = Replace(Replace(fName,".",""),":","")CMD = ""CMD = CMD & "c:" & vbCrLfCMD = CMD & "cd C:\Program Files\MySQL\MySQL Server 5.0\bin\" & vbCrLfCMD = CMD & "mysqldump -u root -p""123456"" test>D:\db_backup\" & fName & ".sql"Dim FileObject,BatFile,BatPathSet FileObject = CreateObject("Scripting.FileSystemObject")BatPath = "c:\backup.bat"Set BatFile = FileObject.CreateTextFile(BatPath, True)BatFile.WriteLine(CMD)BatFile.CloseSet BatFile = NothingSet FileObject = NothingSet WshShell = CreateObject("Wscript.Shell")WshShell.Run BatPath,1,trueSet WshShell = Nothing然后使用Windows的“计划任务”定时执行该批处理脚本即可。(例如:每天凌晨3点执行db_back.vbs) 有时在提问前看看精华贴列表中有些什么会有意外的收获。http://topic.csdn.net/u/20091101/09/c3171263-de12-4311-b8e5-aa17f9940796.html msyql单表统计查询疑难问题 Mysql ignore into的疑问 MYSQL行转例问题 求一条UPDATE 语句! mysqld_multi多实例的配置 mysql 触发器中如何查询同库中的某表中的字段赋值给一个标量 请问, 怎么查看MYSQL 当前的连接数目? 请问哪里用法有误? 有关mysql数据库更新的问题,急急急急急.....在线等待!!! mysql查询6号到24号数据,就是用户在6号到24号中,有5天出现过就查询出来。 innotop的使用方法 请问关于mysql下载问题
内容类似下边这样
mysqldump -uroot -p123 dbname>dbname.sql
存成BAT文件
放到WINDOWS的计划任务中去执行
tNow = Now()
fName = Year(tNow) & FormatNumber(Month(tNow)/100,2,false) & FormatNumber(Day(tNow)/100,2,false) & FormatDateTime(tNow,3)
fName = Replace(Replace(fName,".",""),":","")
CMD = ""
CMD = CMD & "c:" & vbCrLf
CMD = CMD & "cd C:\Program Files\MySQL\MySQL Server 5.0\bin\" & vbCrLf
CMD = CMD & "mysqldump -u root -p""123456"" test>D:\db_backup\" & fName & ".sql"
Dim FileObject,BatFile,BatPath
Set FileObject = CreateObject("Scripting.FileSystemObject")
BatPath = "c:\backup.bat"
Set BatFile = FileObject.CreateTextFile(BatPath, True)
BatFile.WriteLine(CMD)
BatFile.Close
Set BatFile = Nothing
Set FileObject = Nothing
Set WshShell = CreateObject("Wscript.Shell")
WshShell.Run BatPath,1,true
Set WshShell = Nothing然后使用Windows的“计划任务”定时执行该批处理脚本即可。(例如:每天凌晨3点执行db_back.vbs)