I would run mysql -h 192.168.1.161 -u slave2 -p see if the user name and password works. This will also tell us if slave2 can reach your master.
This is only an idea, but you can start over from scratch. Go into your mysql directory on slave2 delete master.info and relay logs that are accumulated so far. Then run "change master to master_host='192.168.1.161', master_user='slave2', master_password='slave2;" that is assuming your user name and password work. This will start over again but since you at position 98. You will catch up to the master in less than 5 minutes. Mike On Mon, Jul 28, 2008 at 5:26 PM, Mary Bahrami <[EMAIL PROTECTED]>wrote: > If that's the master server's master status, then yes, you want to > 'change master to' this on the slave and see if it starts. > > If it doesn't I'd take a fresh mysqldump with the --master-data > parameter and refresh the slave, run the 'change master' statement at > the top of the backup and it should start. > > -----Original Message----- > From: Bryan Irvine [mailto:[EMAIL PROTECTED] > Sent: Monday, July 28, 2008 2:11 PM > To: Mike > Cc: mysql@lists.mysql.com > Subject: Re: slave io status: no wont' change > > here's the master status from the master; > > mysql> show master status; > +------------------+----------+--------------+------------------+ > | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | > +------------------+----------+--------------+------------------+ > | mysql-bin.000023 | 98 | exampledb | | > +------------------+----------+--------------+------------------+ > 1 row in set (0.00 sec) > > ^^^is that the correct posistion? > > -Bryan > > On Mon, Jul 28, 2008 at 2:05 PM, Mike <[EMAIL PROTECTED]> wrote: > > Do you have the original mysql> show slave status\G; off the master? > > > > I have a feeling you have the position wrong. I about 100% sure you > have > > the position wrong because it happened to me. > > > > if you don't have it do a show slave status\G; and try to remember > which one > > you took. > > > > Mike > > > > On Mon, Jul 28, 2008 at 5:02 PM, Bryan Irvine <[EMAIL PROTECTED]> > wrote: > >> > >> Mike, > >> > >> Yes take a peek here: > >> > >> mysql> show master status; > >> +------------------+----------+--------------+------------------+ > >> | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | > >> +------------------+----------+--------------+------------------+ > >> | mysql-bin.000045 | 98 | exampledb | | > >> +------------------+----------+--------------+------------------+ > >> 1 row in set (0.00 sec) > >> > >> > >> mysql> stop slave; > >> Query OK, 0 rows affected (0.00 sec) > >> > >> mysql> change master to master_host='192.168.1.161', > >> master_user='slave2', master_password='slave2', > >> master_log_file='mysql-bin.000045',master_log_pos=98; > >> Query OK, 0 rows affected (0.01 sec) > >> > >> mysql> start slave; > >> Query OK, 0 rows affected (0.00 sec) > >> > >> mysql> show slave status\G; > >> *************************** 1. row *************************** > >> Slave_IO_State: > >> Master_Host: 192.168.1.161 > >> Master_User: slave2 > >> Master_Port: 3306 > >> Connect_Retry: 60 > >> Master_Log_File: mysql-bin.000045 > >> Read_Master_Log_Pos: 98 > >> Relay_Log_File: slave-relay.000001 > >> Relay_Log_Pos: 98 > >> Relay_Master_Log_File: mysql-bin.000045 > >> Slave_IO_Running: No > >> Slave_SQL_Running: Yes > >> Replicate_Do_DB: exampledb > >> Replicate_Ignore_DB: > >> Replicate_Do_Table: > >> Replicate_Ignore_Table: > >> Replicate_Wild_Do_Table: > >> Replicate_Wild_Ignore_Table: > >> Last_Errno: 0 > >> Last_Error: > >> Skip_Counter: 0 > >> Exec_Master_Log_Pos: 98 > >> Relay_Log_Space: 98 > >> Until_Condition: None > >> Until_Log_File: > >> Until_Log_Pos: 0 > >> Master_SSL_Allowed: No > >> Master_SSL_CA_File: > >> Master_SSL_CA_Path: > >> Master_SSL_Cert: > >> Master_SSL_Cipher: > >> Master_SSL_Key: > >> Seconds_Behind_Master: NULL > >> 1 row in set (0.00 sec) > >> > >> ERROR: > >> No query specified > >> > >> > >> > >> On Mon, Jul 28, 2008 at 1:28 PM, Mike <[EMAIL PROTECTED]> wrote: > >> > Did you start from position Exec_Master_Log_Pos 1? Can you tell us > the > >> > command you used to get this going? > >> > > >> > Mike > >> > > >> > On Mon, Jul 28, 2008 at 4:14 PM, Bryan Irvine > <[EMAIL PROTECTED]> > >> > wrote: > >> >> > >> >> I'm having an issue setting up a slave Where it doesn't seem to > start: > >> >> > >> >> mysql> show master status; > >> >> +------------------+----------+--------------+------------------+ > >> >> | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | > >> >> +------------------+----------+--------------+------------------+ > >> >> | mysql-bin.000044 | 98 | exampledb | | > >> >> +------------------+----------+--------------+------------------+ > >> >> 1 row in set (0.00 sec) > >> >> > >> >> mysql> show slave status\G; > >> >> *************************** 1. row *************************** > >> >> Slave_IO_State: > >> >> Master_Host: 192.168.1.161 > >> >> Master_User: slave2 > >> >> Master_Port: 3306 > >> >> Connect_Retry: 60 > >> >> Master_Log_File: mysql-bin.000044 > >> >> Read_Master_Log_Pos: 98 > >> >> Relay_Log_File: slave-relay.000001 > >> >> Relay_Log_Pos: 98 > >> >> Relay_Master_Log_File: mysql-bin.000044 > >> >> Slave_IO_Running: No > >> >> Slave_SQL_Running: Yes > >> >> Replicate_Do_DB: exampledb > >> >> Replicate_Ignore_DB: > >> >> Replicate_Do_Table: > >> >> Replicate_Ignore_Table: > >> >> Replicate_Wild_Do_Table: > >> >> Replicate_Wild_Ignore_Table: > >> >> Last_Errno: 0 > >> >> Last_Error: > >> >> Skip_Counter: 0 > >> >> Exec_Master_Log_Pos: 98 > >> >> Relay_Log_Space: 98 > >> >> Until_Condition: None > >> >> Until_Log_File: > >> >> Until_Log_Pos: 0 > >> >> Master_SSL_Allowed: No > >> >> Master_SSL_CA_File: > >> >> Master_SSL_CA_Path: > >> >> Master_SSL_Cert: > >> >> Master_SSL_Cipher: > >> >> Master_SSL_Key: > >> >> Seconds_Behind_Master: NULL > >> >> 1 row in set (0.00 sec) > >> >> > >> >> ERROR: > >> >> No query specified > >> >> > >> >> mysql> > >> >> > >> >> -- > >> >> MySQL General Mailing List > >> >> For list archives: http://lists.mysql.com/mysql > >> >> To unsubscribe: > >> >> http://lists.mysql.com/[EMAIL PROTECTED] > >> >> > >> > > >> > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > >
