使用Navicat进行定时备份数据库，并用WIndowns定时任务删除文件

以你之姓@ 2023-07-10 05:13 1阅读 0赞

2020年2月29日，新型冠状肺炎还在增长，已经在家里呆了一个月，希望疫情早点结束，武汉加油，中国加油！

本文章主要解决使用数据库工具Ncavicat进行数据的备份，第二是使用WIndowns的bat文件进行定时删除备份的数据库文件。

第一步：数据库定时备份

首先保证数据库正常 ，使用Navicat正连接。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70][]

点击计划-新建批处理作业

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 1][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 2][]

选中可用任务-选中数据库，已选任务中就有选中操作的任务对象。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 3][]

点击保存给任务取名字

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 4][]

保存设置名字后，给计划事件设定任务

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 5][]

在计划栏目选择定时任务，可设置多个定时任务，只要自己喜欢多建几个没问题

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 6][]

点击保存需要输入windowns的管理员密码

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 7][]

任务设定好就出现在计划中的任务框内。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 8][]

我们可以在Navicat程序中文件路径下寻找已经备份好的文件。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 9][]

第二步 使用bat定时删除数据库备份文件

使用记事本创建一个bat的P处理文件，连接告诉开启windowns的选项才能创建（[https://jingyan.baidu.com/article/6b182309603ff4ba58e1591c.html][https_jingyan.baidu.com_article_6b182309603ff4ba58e1591c.html]）

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 10][]

记事本代码：输入一段删除7前数据库文件的话，文件路径在C：\\user....中的psc文件，用户默认在5秒使用默认yes操作。在输出一段正在执行删除数据库操作，请稍等。（可自己在测试文件夹中把路径和名字改一改，执行后文件将会删除，代表代码执行成，接下来就是放入windowns的任务计划时间中）

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 11][]

开始中，搜索任务计划程序

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 12][]

选择创建基本任务，只有时间，名称，操作，如果多选项就创建任务。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 13][]

创建名称，武汉挺住

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 14][]

选择任务触发时间。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 15][]

这里选择每天，设定任务开始时间。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 16][]

下一步操作，选择要执行的P处理程序。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 17][]

浏览找到程序所在

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 18][]

选择刚才用脚本写出来的P处理文件（我有两个库同时备份，所以有两个删除的P处理）

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 19][]

下一步

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 20][]

在任务计划程序窗口就可以看到设的任务，我这里有三个任务是我之前设置在好的。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 21][]

可以执行右边-运行-查看一下bat文件是否正执行。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 22][]

执行脚本后，看看文件下的7天前的备份文件都删除了。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 23][]

总结：Navicat作为MySQL连接工具功能，有备份功能和计划任务功能很强大。注意连接和任务选择时，记得保存设名字才能设置任务内容，备份时间，这个小细节。P处理删除的代码可以用在windowns中，并任务设定删除哪个时间段的文件。加入系统自带的任务计划中，可定时删除，时间由用户自己选择。但对于代码要由一定了解和认识就可设置多个删除任务。

参考连接：

[https://blog.csdn.net/scholar\_man/article/details/80702499][https_blog.csdn.net_scholar_man_article_details_80702499]

[https://www.jb51.net/article/107285.htm][https_www.jb51.net_article_107285.htm]

[https://jingyan.baidu.com/article/6b182309603ff4ba58e1591c.html][https_jingyan.baidu.com_article_6b182309603ff4ba58e1591c.html]

[https://blog.csdn.net/scholar\_man/article/details/80702499][https_blog.csdn.net_scholar_man_article_details_80702499]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200229172039645.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200229172159316.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200229172218446.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20200229172711193.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20200229172832177.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20200229172951577.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 6]: https://img-blog.csdnimg.cn/20200229173100157.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 7]: https://img-blog.csdnimg.cn/2020022917314985.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 8]: https://img-blog.csdnimg.cn/20200229173235673.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 9]: https://img-blog.csdnimg.cn/20200229173342698.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2,size_16,color_FFFFFF,t_70
[https_jingyan.baidu.com_article_6b182309603ff4ba58e1591c.html]: https://jingyan.baidu.com/article/6b182309603ff4ba58e1591c.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 10]: https://img-blog.csdnimg.cn/20200229173713461.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 11]: https://img-blog.csdnimg.cn/20200229173837141.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 12]: https://img-blog.csdnimg.cn/20200229174531939.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 13]: https://img-blog.csdnimg.cn/20200229174632274.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 14]: https://img-blog.csdnimg.cn/2020022917481214.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 15]: https://img-blog.csdnimg.cn/20200229174841205.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 16]: https://img-blog.csdnimg.cn/20200229174848599.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 17]: https://img-blog.csdnimg.cn/20200229174857884.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 18]: https://img-blog.csdnimg.cn/20200229174912640.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 19]: https://img-blog.csdnimg.cn/20200229174925375.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 20]: https://img-blog.csdnimg.cn/20200229174943253.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 21]: https://img-blog.csdnimg.cn/20200229175102657.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 22]: https://img-blog.csdnimg.cn/2020022917504732.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2_size_16_color_FFFFFF_t_70 23]: https://img-blog.csdnimg.cn/20200229175119834.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpMjQ3NjMwNjc2,size_16,color_FFFFFF,t_70
[https_blog.csdn.net_scholar_man_article_details_80702499]: https://blog.csdn.net/scholar_man/article/details/80702499
[https_www.jb51.net_article_107285.htm]: https://www.jb51.net/article/107285.htm