Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

ksh lock a file, [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed, sed: -e expression #1, char 1: unterminated address regex, procmail + change subject, w2ksp4.exe download, /proc/kallsyms format, sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked

Links

XODOX
Impressum

#1: Automated MySQL checks using shell script or maybe Expect

Posted on 2007-08-27 18:22:22 by tommy.geerts

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 ?

Report this message

#2: Re: Automated MySQL checks using shell script or maybe Expect

Posted on 2007-08-27 21:49:15 by Cyrus Kriticos

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

Report this message