Bash, how to mail result?

Question

linux

Good evening, how to send the result of the request by mail?

now it stores in the home directory

Answer 1

supposed to work

mysql -u root -pPAssword -E "zabbix" -e "select * from hosts;" | mail (...тут параметры утилиты mail, гугли или man mail в помощь)

Answer 2

here is a working version
echo SQL DUMP `date +%D-%H:%M:%S` |mail -s "[sqldump]" -A /etc/passwd [email protected]
parameter -A - specifies the file that should be attachment.
and don't forget to gzip the sql code before sending

Answer 3

Choice:

metasend -b -s "$SUBJECT" -f $TXTFILE -m text/plain -e none -n -f $ATTFILE -m application/octet-stream -e base64 -t $MAILTO 
mpack -s "$SUBJECT" -c application/octet-stream $ATTFILE $MAILTO 
mutt -a $ATTFILE -s "$SUBJECT" $MAILTO < $TXTFILE