> I've seen a strange replication problem with MySQL v4.0.12. > > mysql> LOAD DATA LOCAL INFILE '/home/andrew/upload' into table andrew FIELDS > TERMINATED BY ',' lines terminated by '\n';
Hi, This bug is fixed in MySQL 4.0.13 (not released yet). Until then a patch for this is : ===== sql/log_event.cc 1.96 vs edited ===== *** /tmp/log_event.cc-1.96-14055 Sat Jan 18 20:00:24 2003 --- edited/sql/log_event.cc Tue Mar 25 18:29:16 2003 *************** *** 1858,1863 **** --- 1858,1868 ---- String line_term(sql_ex.line_term,sql_ex.line_term_len); String line_start(sql_ex.line_start,sql_ex.line_start_len); String escaped(sql_ex.escaped,sql_ex.escaped_len); + ex.field_term= &field_term; + ex.enclosed= &enclosed; + ex.line_term= &line_term; + ex.line_start= &line_start; + ex.escaped= &escaped; ex.opt_enclosed = (sql_ex.opt_flags & OPT_ENCLOSED_FLAG); if (sql_ex.empty_flags & FIELD_TERM_EMPTY) Regards, Guilhem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]