shellcron定时脚本内附ftp上传每天2点定时导出数据上传到指定目录资源-CSDN文库

共2个文件

sh：1个

cron：1个

需积分: 10 140 浏览量 2014-09-25 14:01:59 上传评论 1 收藏 3KB RAR 举报

在IT行业中，shell脚本和cron服务是Linux系统中常用的任务调度工具，用于自动化执行特定任务，例如在特定时间导出数据并将其上传至FTP服务器。在这个场景中，`unload.sh`是执行数据导出的shell脚本，而`cron.cron`则是设置定时任务的配置文件。让我们详细了解`unload.sh`脚本。这个脚本通常包含一系列Linux命令，如数据备份、格式化、压缩等。它可能包括`tar`命令来打包文件，`gzip`或`bzip2`进行压缩，以及可能使用`find`或`ls`来定位需要处理的文件。例如，一个简单的`unload.sh`脚本可能如下： ```bash #!/bin/bash # 导出数据部分 # 这里可能包含数据库查询或其他数据生成命令 # ... # 压缩导出的数据 tar -czvf data_$(date +%Y%m%d).tar.gz /path/to/exported/data # 输出日志 echo "Data exported and compressed on $(date)" >> export.log ``` 接下来，`cron.cron`文件是用来配置cron服务的。cron服务会在后台定期检查这个配置文件，并根据其中的指令执行任务。每个定时任务由多个字段组成，分别表示分钟、小时、日期、月份和星期几。在这个例子中，任务可能设置为每天凌晨2点执行： ```bash # 打开crontab编辑器 crontab -e # 添加以下行，指定每天的2点0分执行unload.sh 0 2 * * * /path/to/unload.sh ``` 这段配置会告诉cron服务，在每天的凌晨2点0分执行`/path/to/unload.sh`脚本。记得替换`/path/to/unload.sh`为实际脚本路径。然后，`ftp`命令可以用来将生成的压缩文件上传到指定服务器。`ftp`命令行工具允许用户连接到FTP服务器，传输文件。然而，为了安全起见，更常见的是使用`sftp`(SSH文件传输协议)或者`lftp`，尤其是涉及到密码或密钥的传输。例如，使用`sftp`进行上传的命令可能如下： ```bash sftp user@server.com:/remote/path << EOF put /path/to/data_*.tar.gz quit EOF ``` 这将把本地的`data_*.tar.gz`文件上传到服务器的指定路径，`user@server.com`是服务器用户名，`/remote/path`是服务器上的目标目录。这个shell cron定时脚本结合了数据处理、压缩、日志记录以及文件传输功能，实现了一套自动化的数据管理流程。通过合理利用这些工具，IT管理员可以有效提升工作效率，确保数据的安全备份和远程同步。

资源推荐

资源详情

资源评论

收起资源包目录

CRON.rar （2个子文件）

cron.cron 76B

unload.sh 31KB

#!/bin/ksh ####################################################################### # 程序名称: unload.sh # 程序功能: PICC流程控制系统数据库卸载工具 # 编写日期: 2014/07 # 备注: ####################################################################### . ~/.profile date=`date +%Y%m%d` prpdb=flowctrldb@liucheng LPLCEXPDIR=$PWD/LPLCEXP if [ -d $LPLCEXPDIR ] then echo "the directry 'LPLCEXP' is exist!" rm -r $LPLCEXPDIR/* else mkdir $LPLCEXPDIR fi mkdir $LPLCEXPDIR/log $LPLCEXPDIR/unl echo "start prplfl4smain: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log echo "正在导出prplfl4smain表:"`date "+%Y-%m-%d %H:%M:%S"` dbaccess $prpdb <<! set isolation to dirty read; unload to $LPLCEXPDIR/unl/prplfl4smain.unl select * from prplfl4smain where company like '13%'; ! echo "end prplfl4smain: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log compress -f $LPLCEXPDIR/unl/prplfl4smain.unl echo "prplfl4smain表导出完成:"`date "+%Y-%m-%d %H:%M:%S"` echo "start prpdcompany: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log echo "正在导出prpdcompany表:"`date "+%Y-%m-%d %H:%M:%S"` dbaccess $prpdb <<! set isolation to dirty read; unload to $LPLCEXPDIR/unl/prpdcompany.unl select * from prpdcompany where comcode like '13%'; ! echo "end prpdcompany: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log compress -f $LPLCEXPDIR/unl/prpdcompany.unl echo "prpdcompany表导出完成:"`date "+%Y-%m-%d %H:%M:%S"` echo "start prplflidddictionary: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log echo "正在导出prplflidddictionary表:"`date "+%Y-%m-%d %H:%M:%S"` dbaccess $prpdb <<! set isolation to dirty read; unload to $LPLCEXPDIR/unl/prplflidddictionary.unl select * from prplflidddictionary; ! echo "end prplflidddictionary: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log compress -f $LPLCEXPDIR/unl/prplflidddictionary.unl echo "prplflidddictionary表导出完成:"`date "+%Y-%m-%d %H:%M:%S"` echo "start prplfldcode: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log echo "正在导出prplfldcode表:"`date "+%Y-%m-%d %H:%M:%S"` dbaccess $prpdb <<! set isolation to dirty read; unload to $LPLCEXPDIR/unl/prplfldcode.unl select * from prplfldcode; ! echo "end prplfldcode: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log compress -f $LPLCEXPDIR/unl/prplfldcode.unl echo "prplfldcode表导出完成:"`date "+%Y-%m-%d %H:%M:%S"` echo "start prplfl4srepaircount: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log echo "正在导出prplfl4srepaircount表:"`date "+%Y-%m-%d %H:%M:%S"` dbaccess $prpdb <<! set isolation to dirty read; unload to $LPLCEXPDIR/unl/prplfl4srepaircount.unl select * from prplfl4srepaircount where agentcode like '13%'; ! echo "end prplfl4srepaircount: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log compress -f $LPLCEXPDIR/unl/prplfl4srepaircount.unl echo "prplfl4srepaircount表导出完成:"`date "+%Y-%m-%d %H:%M:%S"` echo "start prplfl4srepaircounthistory: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log echo "正在导出prplfl4srepaircounthistory表:"`date "+%Y-%m-%d %H:%M:%S"` dbaccess $prpdb <<! set isolation to dirty read; unload to $LPLCEXPDIR/unl/prplfl4srepaircounthistory.unl select * from prplfl4srepaircounthistory where operatorcode like '13%'; ! echo "end prplfl4srepaircounthistory: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log compress -f $LPLCEXPDIR/unl/prplfl4srepaircounthistory.unl echo "prplfl4srepaircounthistory表导出完成:"`date "+%Y-%m-%d %H:%M:%S"` echo "start prplflvipreserve: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log echo "正在导出prplflvipreserve表:"`date "+%Y-%m-%d %H:%M:%S"` dbaccess $prpdb <<! set isolation to dirty read; unload to $LPLCEXPDIR/unl/prplflvipreserve.unl select * from prplflvipreserve where substr(registno,9,2) = '13'; ! echo "end prplflvipreserve: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log compress -f $LPLCEXPDIR/unl/prplflvipreserve.unl echo "prplflvipreserve表导出完成:"`date "+%Y-%m-%d %H:%M:%S"` echo "start prplfl4sext: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log echo "正在导出prplfl4sext表:"`date "+%Y-%m-%d %H:%M:%S"` dbaccess -e $prpdb >>$LPLCEXPDIR/log/unl_load.log 2>&1 <<! dbaccess $prpdb <<! set isolation to dirty read; unload to $LPLCEXPDIR/unl/prplfl4sext.unl select * from prplfl4sext where agentcode like '13%'; ! echo "end prplfl4sext: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log compress -f $LPLCEXPDIR/unl/prplfl4sext.unl echo "prplfl4sext表导出完成:"`date "+%Y-%m-%d %H:%M:%S"` echo "start prplflclaiminfo: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log echo "正在导出prplflclaiminfo表:"`date "+%Y-%m-%d %H:%M:%S"` dbaccess $prpdb <<! set isolation to dirty read; unload to $LPLCEXPDIR/unl/prplflclaiminfo.unl select * from prplflclaiminfo where substr(registno,9,2) = '13'; ! echo "end prplflclaiminfo: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log compress -f $LPLCEXPDIR/unl/prplflclaiminfo.unl echo "prplflclaiminfo表导出完成:"`date "+%Y-%m-%d %H:%M:%S"` echo "start prplflmaininfo: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log echo "正在导出prplflmaininfo表:"`date "+%Y-%m-%d %H:%M:%S"` dbaccess $prpdb <<! set isolation to dirty read; unload to $LPLCEXPDIR/unl/prplflmaininfo.unl select * from prplflmaininfo where comcode like '13%'; ! echo "end prplflmaininfo: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log compress -f $LPLCEXPDIR/unl/prplflmaininfo.unl echo "prplflmaininfo表导出完成:"`date "+%Y-%m-%d %H:%M:%S"` echo "start prplflitemcar: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log echo "正在导出prplflitemcar表:"`date "+%Y-%m-%d %H:%M:%S"` dbaccess $prpdb <<! set isolation to dirty read; unload to $LPLCEXPDIR/unl/prplflitemcar.unl select * from prplflitemcar where substr(registno,9,2) = '13'; ! echo "end prplflitemcar: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log compress -f $LPLCEXPDIR/unl/prplflitemcar.unl echo "prplflitemcar表导出完成:"`date "+%Y-%m-%d %H:%M:%S"` echo "start prplflthirdcar: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log echo "正在导出prplflthirdcar表:"`date "+%Y-%m-%d %H:%M:%S"` dbaccess $prpdb <<! set isolation to dirty read; unload to $LPLCEXPDIR/unl/prplflthirdcar.unl select * from prplflthirdcar where substr(registno,9,2) = '13'; ! echo "end prplflthirdcar: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log compress -f $LPLCEXPDIR/unl/prplflthirdcar.unl echo "prplflthirdcar表导出完成:"`date "+%Y-%m-%d %H:%M:%S"` echo "start prplflflowmain: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log echo "正在导出prplflflowmain表:"`date "+%Y-%m-%d %H:%M:%S"` dbaccess $prpdb <<! set isolation to dirty read; unload to $LPLCEXPDIR/unl/prplflflowmain.unl select * from prplflflowmain where comcode[1,2] = '13'; ! echo "end prplflflowmain: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log compress -f $LPLCEXPDIR/unl/prplflflowmain.unl echo "prplflflowmain表导出完成:"`date "+%Y-%m-%d %H:%M:%S"` echo "start prplflflowcond: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log echo "正在导出prplflflowcond表:"`date "+%Y-%m-%d %H:%M:%S"` dbaccess $prpdb <<! set isolation to dirty read; unload to $LPLCEXPDIR/unl/prplflflowcond.unl select * from prplflflowcond where comcode[1,2] = '13'; ! echo "end prplflflowcond: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log compress -f $LPLCEXPDIR/unl/prplflflowcond.unl echo "prplflflowcond表导出完成:"`date "+%Y-%m-%d %H:%M:%S"` echo "start prplflconfigcode: "`date "+%Y-%m-%d %H:%M:%S"` >> $LPLCEXPDIR/log/unl_load.log echo "正在导出prplflconfigcode表:"`date "+%Y-%m-%d %H:%M:%S"` dbaccess

评论收藏

内容反馈