服务型网站有哪些,企业网站的购买方式,编程教程,国外 设计师 网站定时备份mysql数据库的批处理代码#xff0c;保存为backup_mysql.bat#xff0c;运行即可。复制代码 代码如下:echo offset txt1%date:~0,4%::当前年set txt2%date:~5,2%::当前月set txt3%date:~8,2%::当前日set txt4%time:~0,2%::当前小时set txt5%time:~3,2%::当前分钟set …定时备份mysql数据库的批处理代码保存为backup_mysql.bat运行即可。复制代码 代码如下:echo offset txt1%date:~0,4%::当前年set txt2%date:~5,2%::当前月set txt3%date:~8,2%::当前日set txt4%time:~0,2%::当前小时set txt5%time:~3,2%::当前分钟set txt6%time:~6,2%::当前秒set date%txt1%%txt2%%txt3%set time%txt4%%txt5%%txt6%echo --------------------------------------------------echo -------------正在执行MySQL数据库备份--------------echo --------------------------------------------------echo ...echo ...echo 导出Database...if exist %date%.sql del %date%.sqlc:\Progr*\mysql\bin\mysqldump --add-drop-table -c -u root -p-h localhost dbname e:\%date%.sqlecho ...echo ...if exist dump%date%.7z del dump%date%.7zecho 压缩文件...7za.exe a -t7z dump%date%.7z %date%.sql -mx9echo ...echo ...echo 删除临时文件del %date%.sqlecho ...echo ...echo 备份完成!pause
