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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]