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. This works fine without problems. 2. I do a LOAD DATA INFILE

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

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?