Hi all,

Apologies if there is an obvious solution to this but I honestly can't see it.

I have a shell script which takes for tables from a mysql db and inserts them into an email and sends them to a given user. It works when run from the command line.

I set up a cron job to fire this script once a week at 1am on Sunday. When the cron jobs runs the emails are sent but are empty. The select doesn't seem to work.

Both scripts are run by root either on the command line or in roots crontab so it shouldn't be a permissions thing?

Any ideas or further questions are welcome.

Sam

Sorry I neglected to mention that the email address is hard coded.

====================Script======================
# Send users table
echo "To:some@email.co.uk;
Subject:'Users table'" > ./mailtemp;
mysql -e "select * from dbname.users" -u someuser --password='somepw' >> ./mailtemp;
/usr/lib/sendmail -t -oi < ./mailtemp;
rm -f ./mailtemp;
====================Script======================

==================Cron Entry====================
################### Data Dump
0 1 * * 0 /scriptlocation/dumpscript.sh
==================Cron Entry====================

The script fires at the right time and send out empty emails.

Sam

Found the answer in another forum.

Wasn't using the full path for mysql, it was following shortcuts from the command line, but couldn't do that from the cron.

If anyone wants to explain the rationale behind that I'd love to know!