写一个vbs文件&＃xff0c;存储在【D:\bugzilla备份文件\bugzilla备份脚本\】路径下&＃xff0c;名称为bugzilla_backup.vbs&＃xff0c;内容为&＃xff1a;

DIM obj

set obj&＃61;wscript.createObject("wscript.shell")

iAnswer&＃61;obj.Run("cmd.exe /C D:\bugzilla备份文件\bugzilla备份脚本\bugzilladump.bat", 0, TRUE)


写一个备分批处理bat文件&＃xff0c;名称为bugzilladump.bat&＃xff0c;存储在【D:\bugzilla备份文件\bugzilla备份脚本\】路径下&＃xff0c;内容为&＃xff1a;

&＃64;echo off

set   bak_dir&＃61;D:\bugzilla_backup\

set   db_type&＃61;mysql

set   db_name&＃61;bugs

set   db_user&＃61;bugs

set   db_pwd&＃61;ilibo-024

set   db_ipadress&＃61;192.168.1.122

set   pweek&＃61;%date:~-1%

set   bakfilename&＃61;%Date:~0,4%%Date:~5,2%%Date:~8,2%


     if not exist %bak_dir% mkdir %bak_dir%

     set filesuffix&＃61;sql

     mysqldump -u%db_user% -p%db_pwd% -h%db_ipadress% %db_name% > %bak_dir%%bakfilename%.%filesuffix%


     goto end


     :end

set   bak_dir&＃61;

set   db_type&＃61;

set   db_name&＃61;

set   db_user&＃61;

set   db_pwd&＃61;

set   pweek&＃61;

set   bakfilename&＃61;

set   filesuffix&＃61;


设置开机自动执行备份&＃xff1a;

cmd&＃xff08;开始-运行&＃xff09;-regedit-HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run-新建-字符串值&＃xff0c;定义名称为Bugzilla_Backup&＃xff0c;修改项值为【D:\bugzilla备份文件\bugzilla备份脚本\bugzilla_backup.vbs】即可&＃xff0c;那么在每次开机时&＃xff0c;系统都会自动备份bugs数据库中的数据到指定目录【D:\bugzilla_backup\】下。