Replication and LOAD DATA INFILE MySQL Max 3.23.56-1

2003-08-04 Thread Richard F. Rebel
Hello, After recently replicating using the stop databases and copy innodb and mysql files method, things were fine... Until the slave thread stopped complaining about duplicate rows after one of our developers did a LOAD DATA INFILE operation on the master. Unfortunately the insert's are into

Re: Replication and LOAD DATA INFILE

2002-10-16 Thread Lothar Jenisch
> Lothar Jenisch wrote: > > >Hello, > > > >I have a problem with replication and LOAD DATA INFILE. > >I use version 3.23.37 on Liunx distribution. > > > >1. I check the replication with a manual i.e. insert and > > delete of one record

Re: Replication and LOAD DATA INFILE

2002-10-15 Thread gerald_clark
Lothar Jenisch wrote: >Hello, > >I have a problem with replication and LOAD DATA INFILE. >I use version 3.23.37 on Liunx distribution. > >1. I check the replication with a manual i.e. insert and > delete of one record. This works fine without problems. >2. I do

Replication and LOAD DATA INFILE

2002-10-15 Thread Lothar Jenisch
Hello, I have a problem with replication and LOAD DATA INFILE. I use version 3.23.37 on Liunx distribution. 1. I check the replication with a manual i.e. insert and delete of one record. This works fine without problems. 2. I do a LOAD DATA INFILE 'file.txt' REPLACE INTO T