Replication Problem

[MaFai]

--=====000_Dragon 786057705063_== ===
Content-Type: text/plain;
charset="big5"
Content-Transfer-Encoding: 7bit

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_Lo g_File: paytv01-bin.003
Slave_IO_Runnin g: Yes
Slave_SQL_Runni ng: No
Replicate_do_db : paytv
Replicate_ignor e_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
zh-ma@hkbn.com.hk
2003-07-28


--=====000_Dragon 786057705063_== ===
Content-Type: text/plain; charset=us-ascii

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw
--=====000_Dragon 786057705063_== ===--