使用mutt定期发送备份到邮箱

#// Path /root/eeBakcupShell/backup-email-mysql-data.sh

#!/bin/sh
dbpwd='***************'
d=`date "+%Y-%m-%d"`
#current data：Year-Month-day

FName=example_$d
#backup file name：yiilib.com_currentData

FP=/root/dbBackup/
#tmp save path, will do auto delete at the end.

mysql -e "show databases;" -uroot -p$dbpwd | grep -Ev "Database|information_schema|mysql|test" | xargs mysqldump -uroot -p$dbpwd --skip-lock-tables --databases  | gzip > $FP$FName.sql.gz
#here has a little trick to find need backup database name: list all database names and return no need backup name(Database|information_schema|mysql|test)，rest will be backup, also add gzip support

echo "backup files"|mutt -s "backup tmp $t" Your_account_name@gmail.com -a $FP$FName.sql.gz
#use Mutt send mail to Your_account_name@gmail.com
# Using Template Mail
# mutt -s "title" Your_account_name@gmail.com -e "set content_type=text/html" < /root/mailBody.html -a attachment.zip
rm -rf $FP$FName.sql.gz
#delete backup gz file

exit
#end

# crontab -e

# //save result to log will help more
15 03 * * * /root/eeBakcupShell/backup-email-mysql-data.sh > /log/eelog.log

~] dnf install mutt
~] mutt -v
Configured with: ../configure --enable-bootstrap --enable-languages=c,c++,fortran,lto --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --with-bugurl=http://bugzilla.redhat.com/bugzilla --enable-shared --enable-threads=posix --enable-checking=release --enable-multilib --with-system-zlib --enable-__cxa_atexit --disable-libunwind-exceptions --enable-gnu-unique-object --enable-linker-build-id --with-gcc-major-version-only --with-linker-hash-style=gnu --enable-plugin --enable-initfini-array --with-isl --disable-libmpx --enable-offload-targets=nvptx-none --without-cuda-driver --enable-gnu-indirect-function --enable-cet --with-tune=generic --with-arch_32=x86-64 --build=x86_64-redhat-linux
Thread model: posix
gcc version 8.3.1 20190507 (Red Hat 8.3.1-4) (GCC)

set ssl_force_tls = yes
set abort_nosubject = no
set mail_check = 60
set timeout = 10
set sort = "reverse-date-received"
set signature = "~/.mutt/signature"
set copy = no

set from = "Your_account_name@QQ.Com"
set realname = "iSuSee"
# Imap settings (Receiving server)
set imap_user = "Your_account_name@QQ.Com"
set imap_pass = "<mutt-app-specific-password>"
set folder = "imaps://imap.exmail.qq.com:993"
# Smtp settings (Sending server)
set smtp_url = "smtps://Your_account_name@QQ.Com@smtp.exmail.qq.com:465/"
set smtp_pass = "<mutt-app-specific-password>"
# Remote gmail folders
set spoolfile = "+INBOX"
set move = no

set editor = "vim"
set sort = "reverse-date-received"
set charset = "utf-8"

set from = "Your_account_name@gmail.com"
set realname = "iSuSee"
# Imap settings
set imap_user = "Your_account_name@gmail.com"
set imap_pass = "<mutt-app-specific-password>"
set folder = "imaps://imap.gmail.com:993"
# Smtp settings
set smtp_url = "smtp://Your_account_name@smtp.gmail.com:587"
set smtp_pass = "<mutt-app-specific-password>"
# Remote gmail folders
set spoolfile = "+INBOX"
set postponed = "+[Gmail]/Drafts"
set record = "+[Gmail]/Sent Mail"
set trash = "+[Gmail]/Trash"
set move = no
# Others
set editor = "vim"
set charset = "utf-8"
# unset ssl_verify_host
set timeout = 300
set imap_keepalive = 300
set header_cache =~/.mutt/cache/headers
set message_cachedir =~/.mutt/cache/bodies
set sort = "reverse-date-received"
set envelope_from=yes

gpg --recipient Your_account_name@QQ.Com --encrypt ~/.mutt/qmail

~] gpg --full-generate-key
gpg (GnuPG) 2.2.20; Copyright (C) 2020 Free Software Foundation, Inc.
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.

Please select what kind of key you want:
   (1) RSA and RSA (default)
   (2) DSA and Elgamal
   (3) DSA (sign only)
   (4) RSA (sign only)
  (14) Existing key from card
Your selection? 1	# 选择加密类型。除非特殊需求，否则键入1 并按 Enter
RSA keys may be between 1024 and 4096 bits long.
What keysize do you want? (2048)	# 选择加密密钥位长，按 Enter接受默认值
Requested keysize is 2048 bits
Please specify how long the key should be valid.
         0 = key does not expire
      <n>  = key expires in n days
      <n>w = key expires in n weeks
      <n>m = key expires in n months
      <n>y = key expires in n years
Key is valid for? (0) 2y	# 指定密钥应持续多长时间，例如2y 两年。密钥将持续24个月，因此需要在两年后进行更新。
Key expires at Thu 23 Jan 2023 08:23:16 PM CST
Is this correct? (y/N) y	# 用确认选择 Y
GnuPG needs to construct a user ID to identify your key.

Real name: iSuSee	# 你的姓
Email address: Your_account_name@QQ.Com	# 你的邮箱
Comment: Sample description
You selected this USER-ID:
    "iSuSee (Sample description) <Your_account_name@QQ.Com>"

Change (N)ame, (C)omment, (E)mail or (O)kay/(Q)uit? O	# 输入 O 确认后，会弹出一个密码框，输入密码并谨记此密码

~] gpg --recipient Your_account_name@QQ.Com --encrypt ~/.mutt/qmail
gpg: checking the trustdb
gpg: marginals needed: 3  completes needed: 1  trust model: pgp
gpg: depth: 0  valid:   1  signed:   0  trust: 0-, 0q, 0n, 0m, 0f, 1u
gpg: next trustdb check due at 2023-01-23

# source /etc/Muttrc.local
source "gpg2 -dq ~/.mutt/qmail.gpg |"

~] gpg2 -dq ~/.mutt/qmail.gpg	# 首先，执行一次解密
echo "This is the content of the email"|mutt -s "The mail title" Your_account_name@QQ.Com	# 纯文本邮件
echo "This is the content of the email"|mutt -s "The mail title" Your_account_name@QQ.Com -a bak.sql.gz		# 带附件的邮件