<div>
echo &quot;&nbsp;MYSQL_STATEMENT&quot; | mysql -u username -p &nbsp;password &nbsp; &gt;&gt;&nbsp;/path/to/file<br />
mail -s 'Daily DB Check - MySQL View' &nbsp;username@mail.domain.tld &lt;&nbsp;/path/to/file<br />

</div>


echo " MYSQL_STATEMENT" | mysql -u username -p  password   >> /path/to/file
mail -s 'Daily DB Check - MySQL View'  username@mail.domain.tld < /path/to/file


<div>
Sorry for the delay on responding. &nbsp;Arober is there a way that I can just have the results placed in the body of the email rather than an attachment?
</div>


Sorry for the delay on responding.  Arober is there a way that I can just have the results placed in the body of the email rather than an attachment?

<div>
#Attach the extracted file to an email, then delete it.<br />
uuencode $TMP_FIR/$CSV_FL_NAME $CSV_FL_NAME | <br />
<br />
Can be changed to<br />
<br />
uuencode $TMP_FIR/$CSV_FL_NAME $CSV_FL_NAME;<br />
mailx $MAILX_REP $REPLY_TO -s &quot;$SUBJECT_LINE&quot; $MAIL_TO &lt;&nbsp;$CSV_FL_NAME;<br />

</div>


#Attach the extracted file to an email, then delete it.
uuencode $TMP_FIR/$CSV_FL_NAME $CSV_FL_NAME |

Can be changed to

uuencode $TMP_FIR/$CSV_FL_NAME $CSV_FL_NAME;
mailx $MAILX_REP $REPLY_TO -s "$SUBJECT_LINE" $MAIL_TO < $CSV_FL_NAME;


<div>
<div class="content wysiwyg-content">
I have a View that I created on my MySQL database that I would like emailed to me daily so I can monitor some data. &nbsp;I just have no idea on how to write a script to do this. &nbsp;Can anyone help?
</div>
</div>


I have a View that I created on my MySQL database that I would like emailed to me daily so I can monitor some data.  I just have no idea on how to write a script to do this.  Can anyone help?

Bash script to email me data from MySQL on Linux server

The term 'shell' refers to a general class of text-based command interpreters most often associated with the UNIX and Linux operating systems. Popular shells include Bourne, Debian Almquist (dash), Korn (ksh), Bourne Again (bash) and the C shell family (csh). Some view the DOS 'cmd' prompt as a minimal shell of sorts. It is also possible to install Cygwin on Windows and emulate a full Unix environment with complete shell capabilities. Terminal emulators, such as xterm, GNOME Terminal and OS X Terminal, can be used to access shell.

Shell Scripting

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Kernel programming for Linux operating systems can be done with many different languages; C, C++, Python, Perl and Java, which are some of the most common languages used.There are also many different varieties of Linux, such as Ubuntu, Fedora and OpenSUSE.