Checking the mysql status

2003-08-14 Thread MaFai
Hello, mysql, I want to write a shell script to check the slave synchronize with master failed or sucessfully. Any idea to implement this? Best regards. MaFai [EMAIL PROTECTED] 2003-08-11 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Checking the mysql status

2003-08-10 Thread Rich Allen
this is a Perl script, not shell ... #!/usr/bin/perl use strict; use DBI; # change the next four to match your network my $SLAVE_IP= '0.0.0.0'; my $MASTER_IP = '0.0.0.0'; my $USER= 'user'; my $PASSWORD= 'password'; my ( $dbh, $sth, @masterResult, @slaveResult, $i );