My best guess would be that your slave tables have slightly different data/structure than your master table. Try taking a fresh snapshot from the master and trying again.
-Eric On Tue, 12 Oct 2004 10:33:24 -0700, Kenneth Lim <[EMAIL PROTECTED]> wrote: > Hi - > > I'm seeing these error/warning messages on my replication slave: > > [ERROR] Slave: load data infile on table 'DeviceItem' at log position > 38844696 in log 'db1-bin.000001' produced 6 warning(s). Default database: > 'senvidsysdb' > > I was wondering if anyone has seen similar messages. > I have master-slave replication setup on 2 Linux boxes running > MySQL 4.1.5-gamma. On a Windows client, I execute a script that > contains a bunch of LOAD DATA LOCAL INFILE statements. > > The master error log does not complain. But the slave error log > has the error/warning messages above. The data seems to be the > same on master and slave. > > Are there special considerations for using LOAD DATA LOCAL INFILE > statements with a replication setup? > > Thanks. > -ken > > Kenneth Lim > Software Engineer > Senvid, Inc. > 2445 Faber Place, Suite #200 > Palo Alto, CA 94303 > phone: 650-354-3612 > fax: 650-354-8890 > email: [EMAIL PROTECTED] > http://www.senvid.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
