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]
