Hi all, I've seen a strange replication problem with MySQL v4.0.12.
Steps to duplicate... I have a table 'andrew'.. mysql> desc andrew; +-------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+-------------+------+-----+---------+-------+ | f1 | varchar(10) | YES | | NULL | | | f2 | varchar(10) | YES | | NULL | | +-------+-------------+------+-----+---------+-------+ 2 rows in set (0.00 sec) And a text file '/home/andrew/upload' that looks like this... hell0,hello hi,hi When I issue the following command on the master: mysql> LOAD DATA LOCAL INFILE '/home/andrew/upload' into table andrew FIELDS TERMINATED BY ',' lines terminated by '\n'; Query OK, 2 rows affected (0.01 sec) cords: 2 Deleted: 0 Skipped: 0 Warnings: 0 The resulting table on the master looks like this.. mysql> select * from andrew; +-------+-------+ | f1 | f2 | +-------+-------+ | hell0 | hello | | hi | hi | +-------+-------+ 2 rows in set (0.00 sec) But on the slave looks it like this... mysql> select * from andrew; +------------+------+ | f1 | f2 | +------------+------+ | hell0,hell | NULL | | hi,hi | NULL | +------------+------+ 2 rows in set (0.00 sec) Weird hey? Works fine with tab delimited files. Any ideas anyone? Cheers, Andrew Sql,query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
