Forum Stats

  • 3,732,985 Users
  • 2,246,666 Discussions
  • 7,856,453 Comments

Discussions

MySQL Windows

User_KG826
User_KG826 Member Posts: 1 Red Ribbon

Hello, I am trying to figure out how to create a script in powershell if possible that is somewhat like the mysql SHOW SLAVE STATUS\G; command.  Basically I would like to run a script that checks for SLAVE_IO_RUNNING, SLAVE_SQL_RUNNING, LAST_ERRNO and SECONDS_BEHIND_MASTER this way my backup can stop the service run the backup job and this would ensure that my slave was in good health when backup process began.  I am hoping someone can help me out.  By the way MySQL is running on a windows environment.  Thx Paulo

Sign In or Register to comment.