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

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 TABLE table F

Change string quote char

2002-07-25 Thread Lothar Jenisch
Hi, is it possible to change the default string quoting chars ('")? I'm using MySQL with an older shop solution. The data to write has both: ' and " chararcters. It isn't possible to escape those chars. Therefor I have to change the quoting char to a char that isn't used i.e "#". Is it possible