Linux cron作业从电子邮件输出命令 [英] Linux cron job to email output from a command

问题描述

我想运行一个cron作业来备份一些mysql数据库，将输出传递到一个文件，然后通过电子邮件发送。 p>

  15 2 * * * root mysqldump -u root -pPASSWORD --all-databases | \ $ b $ g gzip> /database_`data'+%m-%d-%Y'`.sql.gz | \ 
 mail -sReport 05/06/[e-mail]< /database_`data'+%m-%d-%Y'`.sql.gz 
  

解决方案

脚本有几个问题，我在下面改变了，注意空格的变化，拼写 date | ; 。

但是， mail 很遗憾，无法发送附件。您可以使用uuencode将该文件嵌入到邮件中：

  15 2 * * * root mysqldump -uroot -pPASSWORD  - 所有数据库| gzip> / database_`date +'％m-％d-％Y'`.sql.gz; uuencode / database_`date +'％m-％d-％Y'`.sql.gz / dev / stdout | mail -sReport 05/06/[e-mail] 
  

或者如果您想（需要安装MetaMail）：

  15 2 * * * root mysqldump -uroot -pPASSWORD  - -all-databases | gzip> / database_`date +'％m-％d-％Y'`.sql.gz; metasend -b -t [e-mail] -sReport 05/06/07-m application / gzip -f / database_`date +'％m-％d-％Y'`.sql.gz 
 

或如上安装mpack，而不是MetaMail：

  15 2 * * * root mysqldump -uroot -pPASSWORD --all-databases | gzip> / database_`date +'％m-％d-％Y'`.sql.gz; mpack -sReport 05/06/07-c application / gzip / database_`date +'％m-％d-％Y'`.sql.gz [e-mail] 
  




I would like to run a cron job to backup some mysql databases by piping the output to a file and then emailing it.

Will the following work?

15 2 * * * root mysqldump -u root -pPASSWORD --all-databases | \
    gzip > /database_`data'+%m-%d-%Y'`.sql.gz | \
    mail -s "Report 05/06/07" [e-mail] < /database_`data'+%m-%d-%Y'`.sql.gz

解决方案

There are a couple of problems with your script, I have altered it below, note carefully the change of spaces, spelling of date and replacement of | for ;.

The most interesting problem however is that mail unfortunately can't send attachments. You could use uuencode to embed the file in the mail using:

15 2 * * * root mysqldump -uroot -pPASSWORD --all-databases | gzip > /database_`date +'%m-%d-%Y'`.sql.gz ; uuencode /database_`date +'%m-%d-%Y'`.sql.gz /dev/stdout | mail -s "Report 05/06/07" [e-mail]

Or if you want to have a proper MIME attachment use (You will need MetaMail installed):

15 2 * * * root mysqldump -uroot -pPASSWORD --all-databases | gzip > /database_`date +'%m-%d-%Y'`.sql.gz ; metasend -b -t [e-mail] -s "Report 05/06/07" -m application/gzip -f /database_`date +'%m-%d-%Y'`.sql.gz

Or as above with mpack installed, instead of MetaMail:

15 2 * * * root mysqldump -uroot -pPASSWORD --all-databases | gzip > /database_`date +'%m-%d-%Y'`.sql.gz ; mpack -s "Report 05/06/07" -c application/gzip /database_`date +'%m-%d-%Y'`.sql.gz [e-mail]

这篇关于Linux cron作业从电子邮件输出命令的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！