Hello all. I have a question that I imagine will be very easy for somebody. I have created a small script that will check my mysql database for any corruption. The script is a cron job and will run once a week. Here is the script:

#!/bin/sh
MYISAMCHK=/usr/bin/myisamchk

#Clear Old Contents Of pulseofac_db.log
cat /dev/null > /var/log/pulseofac_db.log

#Check MyIsam Tables
$MYISAMCHK --fast /var/lib/mysql/pulseofac/*.MYI >> /var/log/pulseofac_db.log

As you can see its fairly straight forward. The output of the myisamchk is concatenated to a text file. I would like to make it so that this text file gets mailed to root@localhost once a week as well. I couldn't find what I was looking for in the man pages of the 'mail' command.

How can I specify a text file to be the subject of the e-mail?

If you don't dump the result of myisamchk to pulseofac_db.log, then it will be delivered as output of the cronjob (and mailed to root if the settings arent telling to drop mail). Else change the last line to read "$MYISAMCHK --fast /var/lib/mysql/pulseofac/*.MYI| mail -s "Myisamchk results" <mail address>", or if you prefer a MIME attachment add a line: "mpack -s "Myisamchk results" /var/log/pulseofac_db.log <mail address>".
Don't forget to zap the log afterwards.

Okay thanks unSpawn. I dumped the whole logging to a text file thing and just had it mail it right to me. I though their would be some sort of switch that you would have to use to specify that it was the content of the e-mail. Guess not.

Thanks man.