What's the best way to automatically query several dozen MySQL databases with a script on a nightly basis? The script usually returns no results, so I'd ideally have it email or notify me if any are ever returned.
I've looked into PHP, Ruby and Python for this, but I'm a little stumped as to how best to handle this.
I believe the only one can answer this question is you. All 3 examples you gave can do what you need to do with cron to automate the job. But the best script language to be used is the one you are most comfortable to use.
What's the best way to automate running MySQL scripts on several databases on a daily basis?