hankknight
asked on
MySQL from crontab
I created a file named "dbrun.sh":
When I run the file like this the MySQL queries in the MySQL get exicuted:
mysql -u zooph -ppass123 -h m.example.com zooph_db < /usr/home/zooph/cron/cron.sql > /dev/null
touch /usr/home/zooph/cron/cron.txt
When I run the file like this the MySQL queries in the MySQL get exicuted:
sh dbrun.sh
However when the crontab does NOT run the SQL dump:*/1 * * * * sh /usr/home/zooph/cron/dbrun.sh
The "touch" command works but not the MySQL dump.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.