Hello, mysql,
1 master and 1 slave replicated successfully.
After I change the master IP address.
So the slave can not replicate the master data.
Then I type change master to 'new ip'.

Show slave status show that an error log found.

How can I slove this? 

Log:
mysql> show slave status\G
*************************** 1. row ***************************
          Master_Host: 192.168.80.18
          Master_User: mafai
          Master_Port: 3306
        Connect_retry: 60
      Master_Log_File: paytv01-bin.012
  Read_Master_Log_Pos: 37468899
       Relay_Log_File: paytv02-relay-bin.001
        Relay_Log_Pos: 6436
Relay_Master_Log_File: paytv01-bin.003
     Slave_IO_Running: Yes
    Slave_SQL_Running: No
      Replicate_do_db: paytv
  Replicate_ignore_db:
           Last_errno: 1050
           Last_error: error 'Table 'p_address_book' already exists' on query 'c
reate table p_address_book(
        refno           int not null,
        name            varchar(30),
        group_name      varchar(20),
        phone           int(8),
        email           varchar(50)
) TYPE=INNODB'
         Skip_counter: 0
  Exec_master_log_pos: 6258
      Relay_log_space: 47656748
1 row in set (0.06 sec)


Best regards. 

MaFai
[EMAIL PROTECTED]
2003-07-28

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to