slave io status: no wont' change
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.44 | 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.44 Read_Master_Log_Pos: 98 Relay_Log_File: slave-relay.01 Relay_Log_Pos: 98 Relay_Master_Log_File: mysql-bin.44 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]
Re: slave io status: no wont' change
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.44 | 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.44 Read_Master_Log_Pos: 98 Relay_Log_File: slave-relay.01 Relay_Log_Pos: 98 Relay_Master_Log_File: mysql-bin.44 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]
Re: slave io status: no wont' change
Mike, Yes take a peek here: mysql show master status; +--+--+--+--+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +--+--+--+--+ | mysql-bin.45 | 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.45',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.45 Read_Master_Log_Pos: 98 Relay_Log_File: slave-relay.01 Relay_Log_Pos: 98 Relay_Master_Log_File: mysql-bin.45 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.44 | 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.44 Read_Master_Log_Pos: 98 Relay_Log_File: slave-relay.01 Relay_Log_Pos: 98 Relay_Master_Log_File: mysql-bin.44 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]
Re: slave io status: no wont' change
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.45 | 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.45',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.45 Read_Master_Log_Pos: 98 Relay_Log_File: slave-relay.01 Relay_Log_Pos: 98 Relay_Master_Log_File: mysql-bin.45 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.44 | 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.44 Read_Master_Log_Pos: 98 Relay_Log_File: slave-relay.01 Relay_Log_Pos: 98 Relay_Master_Log_File: mysql-bin.44 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]
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.23 | 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.45 | 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.45',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.45 Read_Master_Log_Pos: 98 Relay_Log_File: slave-relay.01 Relay_Log_Pos: 98 Relay_Master_Log_File: mysql-bin.45 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.44 | 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.44 Read_Master_Log_Pos: 98 Relay_Log_File: slave-relay.01 Relay_Log_Pos: 98 Relay_Master_Log_File: mysql-bin.44 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:
RE: slave io status: no wont' change
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.23 | 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.45 | 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.45',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.45 Read_Master_Log_Pos: 98 Relay_Log_File: slave-relay.01 Relay_Log_Pos: 98 Relay_Master_Log_File: mysql-bin.45 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.44 | 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.44 Read_Master_Log_Pos: 98 Relay_Log_File: slave-relay.01 Relay_Log_Pos: 98 Relay_Master_Log_File: mysql-bin.44 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
Re: slave io status: no wont' change
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.23 | 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.45 | 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.45',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.45 Read_Master_Log_Pos: 98 Relay_Log_File: slave-relay.01 Relay_Log_Pos: 98 Relay_Master_Log_File: mysql-bin.45 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.44 | 98 | exampledb| | +--+--+--+--+ 1 row in set (0.00 sec) mysql show slave status\G; *** 1. row
Re: slave io status: no wont' change
whoops! nevermind I just found it. Both of the servers had a server-id of 1. *blush* On Mon, Jul 28, 2008 at 2: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.23 | 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.45 | 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.45',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.45 Read_Master_Log_Pos: 98 Relay_Log_File: slave-relay.01 Relay_Log_Pos: 98 Relay_Master_Log_File: mysql-bin.45 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.44 | 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.44 Read_Master_Log_Pos: 98 Relay_Log_File: slave-relay.01 Relay_Log_Pos: 98 Relay_Master_Log_File: mysql-bin.44 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
