473,322 Members | 1,405 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Replication Problem

--=====000_Dragon786057705063_=====
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_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
zh***@hkbn.com.hk
2003-07-28
--=====000_Dragon786057705063_=====
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/my***********...ie.nctu.edu.tw
--=====000_Dragon786057705063_=====--

Jul 19 '05 #1
0 1229

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Andras Kovacs | last post by:
We have a performance problem to replicate our environnement. Our java code is able to insert 100 000 rows in a table within 3 seconds using Batch Statement. For two oracle sites it takes 6...
1
by: Damian H | last post by:
Hi, For some magical reason, my database replication has suddenly stopped working. I modified the publication but the Distribution agent will not run; the snapshot does not get applied to the...
3
by: mark | last post by:
HELP!!! Last week we moved the Server From 1 Location to Another that was running Replication Manager 4.0. (We changed the IP Addresses and changed the name servers also... ) After the...
2
by: HJ | last post by:
Hi all, I am looking at a problem we encountered with replication. Our front-end and back-end are Microsoft Access 2000. We have a design master at the server and replicas at five notebooks. The...
10
by: Daven Thrice | last post by:
I have a database that needs to be replicated over the Internet. I was hoping it would be a simple task, but apparently it is not. I've started browsing the msdn article on the topic. In the...
56
by: Raphi | last post by:
Hi, I've been using an Access application I wrote for an office with the front-end stored on all computers and the back-end on one of them serving as an Access file server. Now we're moving...
9
by: David W. Fenton | last post by:
See: Updated version of the Microsoft Jet 4.0 Service Pack 8 replication files is available in the Download Center http://support.microsoft.com/?scid=kb;en-us;321076 This includes the Jet 4...
8
by: sat | last post by:
Hi All! I have a small doubt in replication.Previously i was working on replication with the databases under the same instance.So it worked fine. Now i'm facing a new problem which is like, now...
3
by: Gert van der Kooij | last post by:
Hi, Our SQL Replication is between DB2 databases on Windows servers. I'm searching for the document which tells me how to migrate our SQL Replication environment from V8 to V9 (we also need to...
8
by: Benzine | last post by:
Hi, I have an issue with my replication at the moment. I will try to describe the scenario accurately. I am using MS SQL 2000 SP4 with Merge Replication. Subscribers connect to the publisher...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.