Automated MySQL checks using shell script or maybe Expect

Hi ,

for a customer i need to create a script that logs into mysqladmin and
within the program i want to execute the following commands

ndb_mgm
show

Is it possible to automate this and get the output to be sent to my
email address ?

Re: Automated MySQL checks using shell script or maybe Expect

TheH wrote:

> for a customer i need to create a script that logs into mysqladmin and
> within the program i want to execute the following commands
>
> ndb_mgm
> show
>
> Is it possible to automate this and get the output to be sent to my
> email address ?

I don't know a solution with mysqladmin.


ndb_mgm -e show --connect-string= | mail -s "cluster status"
you@example.com

--
Best regards | "The only way to really learn scripting is to write
Cyrus | scripts." -- Advanced Bash-Scripting Guide