I have managed to schedule a bash script to backup several tables on an hourly basis. How can I send these tables as attachments, using the Schedule ? I've tried Bash with sendmail or mail or mailx - it seems these are not available or installed.
With Mutt which seems to be installed:
mutt -s “this is a test” myemail@gmail.com -a /home/UserName/FileName.sql < /home/UserName/MsgBody.txt
I've tried with and without quotes and other variations... I get the following error again and again: sendmail: Cannot open mail:25 Error sending message, child exited 1 (). Could not send the message.
What shall I use to automatically send as an attachment to an email a couple of files ? Thanks