Another problem with load data and replication? I've identified 2 confirmed bugs in the last 2 releases. Honestly, I've pretty much given up on using load data on my master server for the time being. I'm now using scripts that generate extended insert statements instead.
--jeff ----- Original Message ----- From: "Andrew Braithwaite" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 01, 2003 10:09 AM Subject: load data infile not being replicated properly.... > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
