I have a script that runs fine if I invoke it from the command line, using Bash. But when cron tries to run it, it fails with a "mysql: command not found" error.
I think this is because cron is not using bash as it's shell, but I can't figure out how to make cron use bash.
I tried adding this to the top of the script:
But no joy. How do I force cron to use bash as it's shell? I'm kind of new to bash and cron, so I may be missing something simple. I read several serverfault posts (would link to them all, but I can't, new user) and tried to understand and apply the info as best I could, plus googled a ton, but am stuck.