Hello Neubyr,
On 1/29/2014 7:16 PM, neubyr wrote:
I am trying to understand MySQL statement based replication with LOAD DATA
LOCAL INFILE statement'.
According to manual -
https://dev.mysql.com/doc/refman/5.0/en/replication-features-load.html -
LOAD DATA LOCAL INFILE is replicated as LOAD DATA
:
Hello Neubyr,
On 1/29/2014 7:16 PM, neubyr wrote:
I am trying to understand MySQL statement based replication with LOAD DATA
LOCAL INFILE statement'.
According to manual -
https://dev.mysql.com/doc/refman/5.0/en/replication-features-load.html -
LOAD DATA LOCAL INFILE is replicated as LOAD
I am trying to understand MySQL statement based replication with LOAD DATA
LOCAL INFILE statement'.
According to manual -
https://dev.mysql.com/doc/refman/5.0/en/replication-features-load.html -
LOAD DATA LOCAL INFILE is replicated as LOAD DATA LOCAL INFILE, however, I
am seeing it replicated
If I don't mistake, there are some parameters to make that you are saying.
Check statement-based-replication and row-based-replication. I think that
this could help you.
Regards,
Antonio.
On Thursday 27 March 2003 14:22, Sohail Hasan wrote:
I am running mysql 4.0.12 on both the master and slave servers. I am
facing the same problem with a slight variation. When I am trying to
import my database dump on the master the replication fails and slave
thread exits with the following
wrote:
cut
Subject: BUG: Load data infile replication - 3.23.56
Replication doesn't seem to be replicating LOAD DATA INFILE
correctly in
3.23.56. Starting with a master and slave that were in sync, I
imported a
file:
cut
Most probably slave is out of sync with master BEFORE you issue LOAD
On Tue, Mar 25, 2003 at 11:05:06PM -0800, Jeff Kilbride wrote:
Replication doesn't seem to be replicating LOAD DATA INFILE correctly in
3.23.56. Starting with a master and slave that were in sync, I imported a
file:
[snip]
Notice that the slave doesn't skip the records that the master does,
Jeremy,
Also, is there any way to find out what records were skipped and
why?
Nope. Not yet. I think that's coming in 4.1?
Yes and no: http://www.mysql.com/doc/en/SHOW_WARNINGS.html
The MySQL server sends back the total number of warnings and errors
you got for the last command.
My
Replication doesn't seem to be replicating LOAD DATA INFILE correctly in
3.23.56. Starting with a master and slave that were in sync, I imported a
file:
---
MASTER
mysql select count(*) from list where sourceID=0;
+--+
| count(*) |
+--+
|0 |