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]