Unix Shell - Automated MySQL checks using shell script or maybe Expect

Author

Automated MySQL checks using shell script or maybe Expect

TheH

2007-08-27, 1:25 pm

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 ?

Cyrus Kriticos

2007-08-27, 7:22 pm

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=<your-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