{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fcharset0 Arial;}{\f1\fswiss\fprq2\fcharset0 Arial;}} {\colortbl ;\red255\green0\blue0;\red0\green0\blue0;} \viewkind4\uc1\pard\f0\fs20 Sorry for the wrong file. I made some chnages so it gets changed. I have done reset MASTER so previous file gets deleted.\par \par This new configuration I done with new output of command.\par \par \cf1\f1 On Master (x.x.x.x)\cf0\f0\par \par mysql> \cf2\b\f1 RESET MASTER;\cf0\b0\f0\par Query OK, 0 rows affected (0.06 sec)\par \par mysql> \cf2\b\f1 insert into account values(3,5);\cf0\b0\f0\par Query OK, 1 row affected (0.00 sec)\par \par mysql> \cf2\b\f1 show master status \\G\cf0\b0\f0\par *************************** 1. row ***************************\par File: .\cf2\b\f1 000002\cf0\b0\f0\par Position: 206\par Binlog_Do_DB:\par Binlog_Ignore_DB:\par 1 row in set (0.00 sec)\par \par mysql> \cf2\b\f1 insert into account values(4,5);\cf0\b0\f0\par Query OK, 1 row affected (0.00 sec)\par \par mysql> show master status \\G\par *************************** 1. row ***************************\par File\cf2\b\f1 : .000002\cf0\b0\f0\par Position: 306\par Binlog_Do_DB:\par Binlog_Ignore_DB:\par 1 row in set (0.00 sec)\par \par \par mysql> show slave status \\G\par *************************** 1. row ***************************\par Slave_IO_State: Waiting to reconnect after a failed master event\par read\par Master_Host: 10.77.176.22\par Master_User: slave_user\par Master_Port: 3306\par Connect_Retry: 60\par Master_Log_File: .000002\par Read_Master_Log_Pos: 309\par Relay_Log_File: ps4743-relay-bin.000009\par Relay_Log_Pos: 4\par Relay_Master_Log_File: .000002\par Slave_IO_Running: No\par Slave_SQL_Running: Yes\par Replicate_Do_DB:\par Replicate_Ignore_DB:\par Replicate_Do_Table:\par Replicate_Ignore_Table:\par Replicate_Wild_Do_Table:\par Replicate_Wild_Ignore_Table:\par Last_Errno: 0\par Last_Error:\par Skip_Counter: 0\par Exec_Master_Log_Pos: 309\par Relay_Log_Space: 212\par Until_Condition: None\par Until_Log_File:\par Until_Log_Pos: 0\par Master_SSL_Allowed: No\par Master_SSL_CA_File:\par Master_SSL_CA_Path:\par Master_SSL_Cert:\par Master_SSL_Cipher:\par Master_SSL_Key:\par Seconds_Behind_Master: NULL\par Master_SSL_Verify_Server_Cert: No\par Last_IO_Errno: 2003\par Last_IO_Error: error reconnecting to master 'slave_user@10.77.17\par 6.22:3306' - retry-time: 60 retries: 86400\par Last_SQL_Errno: 0\par Last_SQL_Error:\par 1 row in set (0.00 sec)\par \par \cf1\f1\par On SLave Side (y.y.y.y)\cf0\f0\par \par \par mysql> \cf2\b\f1 STOP SLAVE;\cf0\b0\f0\par Query OK, 0 rows affected (36.88 sec)\par \par mysql> CHANGE MASTER TO MASTER_HOST='10.77.176.105', MASTER_USER='slave_user', M\par ASTER_PASSWORD='password', \cf2\b\f1 MASTER_LOG_FILE='.000002', MASTER_LOG_POS=206;\cf0\b0\f0\par Query OK, 0 rows affected (0.00 sec)\par \par \par \par mysql> show slave status \\G\par *************************** 1. row ***************************\par Slave_IO_State:\par Master_Host: 10.77.176.105\par Master_User: slave_user\par Master_Port: 3306\par Connect_Retry: 60\par Master_Log_File: .000002\par Read_Master_Log_Pos: 206\par Relay_Log_File: vm-win2000advsr1-relay-bin.000001\par Relay_Log_Pos: 4\par Relay_Master_Log_File: .000002\par Slave_IO_Running: No\par Slave_SQL_Running: No\par Replicate_Do_DB:\par Replicate_Ignore_DB:\par Replicate_Do_Table:\par Replicate_Ignore_Table:\par Replicate_Wild_Do_Table:\par Replicate_Wild_Ignore_Table:\par Last_Errno: 0\par Last_Error:\par Skip_Counter: 0\par Exec_Master_Log_Pos: 206\par Relay_Log_Space: 106\par Until_Condition: None\par Until_Log_File:\par Until_Log_Pos: 0\par Master_SSL_Allowed: No\par Master_SSL_CA_File:\par Master_SSL_CA_Path:\par Master_SSL_Cert:\par Master_SSL_Cipher:\par Master_SSL_Key:\par Seconds_Behind_Master: NULL\par Master_SSL_Verify_Server_Cert: No\par Last_IO_Errno: 1130\par Last_IO_Error: error connecting to master 'slave_user@10.77.176.\par 105:3306' - retry-time: 60 retries: 86400\par Last_SQL_Errno: 0\par Last_SQL_Error:\par 1 row in set (0.00 sec)\par \par }