Shell Programming and Scripting

I need to modify a script to send an attatched file. I have researched and read the faq's but have not found a solution for my script. Here is a copy of the code I am using:

Code:

#!/bin/sh


mysqldump --opt --skip-add-locks --user=****** --password=******* databasename | gzip > /home/******/backups/Databasename_`date "+%Y-%m-%d"`.gz
cd /home/*****/backups/
find *.gz -mtime +7 -exec rm -rf {} \;

This script copies the database and saves it to the "backups" file and deletes the files older than 7 days. I would like to add code to email the gziped file to an email account also.

Any help is greatly appreciated.

Didn't this help ?

https://www.unix.com/shell-programmin...ding-mail.html

I am not a coder, so was not sure how I could incorporate it....

I read over that post again, and still can not find what I need.

What I want to do is incorporate in the code I posted above, to send the file to my email as well as save it to the backups file as is coded.
The problem I have with suggested examples is that they all specify a specific file. The code above generates a new file with a different name everyday, and that is where I have the hang up.

Thanks for your help in this.