Use crontab:
0mysql -e 'show slave status\G;' | mail -v email@stripped
2008/5/2, David Gardner <djgardner@stripped>:
>
> Hello,
>
> Has any one created a script to email the results of the command:
>
>
> SHOW SLAVE STATUS\G
> Automation is desired.
>
> /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
> David Gardner
> email: djgardner(at)yahoo.com
> Yahoo! IM: djgardner
> AIM: dgardner09
>
>
> "Everything is a learning experience, even a mistake."
>
>
>
>
>
> ____________________________________________________________________________________
> Be a better friend, newshound, and
> know-it-all with Yahoo! Mobile. Try it now.
> http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
>
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:
> http://lists.mysql.com/replication?unsub=1
>
>