数据库
文章平均质量分 62
flon
这个作者很懒,什么都没留下…
展开
-
windows下Mysql定时备份数据库(支持自动删除过期备份)
写MySQL备份及过期处理bat脚本整理所需批处理指令,保存为一个Bat文件@echo offset "yMd=%date:~0,4%%date:~5,2%%date:~8,2%"set "hms=%time:~0,2%%time:~3,2%%time:~6,2%"set "bakdays=10"set "dumpPath=D:\Program Files\MySQL\mysql-8.0.28-winx64\bin\mysqldump.exe"set "user=root"...原创 2022-04-07 14:30:03 · 1077 阅读 · 0 评论 -
Shell脚本批量清理ES中的过期数据
#!/bin/bashESURL=http://127.0.0.1:9200Savingdays=70# 传入索引名,删除索引function delete_es_index(){ printf "deleting index: $1 \r\n"curl -u elastic:tianyan -XDELETE "$ESURL/$1" > /dev/null 2>&1#printf elastic:tianyan -XDELETE "$ESURL/$1" > /...原创 2020-09-18 11:01:55 · 710 阅读 · 0 评论 -
实现自动备份sqlserver代理作业JOB
step1 阅读WindowShell脚本$ServerName='XXX'$FilePath='XX'echo $env:COMPUTERNAMEecho $ServerNameif(Test-Path $FilePath){ #check if the instance name is available on the server [System.Reflection.Assembly]::LoadWithPartialNa...原创 2020-08-31 19:18:31 · 595 阅读 · 0 评论