Replication and LOAD DATA INFILE

Hello to you all people,

      I don't know if this is a good time to be asking question. But I will try to describe this problem the best I can. Ok. Let's see. We have 1 MASTER and 1 SLAVE.
Both having MySQL 5.0.41. My.conf are configured with lots of thought and calculations. The big thing is that the replication breaks every day. Now we have a
pretty good reason after viewing the position where it breaks is the DATA from the text file.

example..
Opened with ultra edit.
-this is how the data starts from the file.... some mysql encrypted
commands, looks like it... however I copied and some characters are not like in ultra edit....
-but you know what it is...
-i copied this from the bin file MYSERVER.000001

Ć8 őKe  LOTS of data

őXŐF

   Å” µLe 0

      N @
P std   tur LOAD DATA INFILE 'c:\\database\\qiqo\\WTRACS\\UNILINE\\FIALA\\FIALA1.asc' INTO TABLE `A070829133101717559` (ID_polje)˙XŐF

And now comes the command

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

MASTER loads the data nicely. But the slave breaks.

Slave err. file
070829 13:40:35 [ERROR] Error reading packet from server: error reading log entry ( server_errno=1236)
070829 13:40:35 [ERROR] Got fatal error 1236: 'error reading log entry' from master when reading data from binary log 070829 13:40:35 [Note] Slave I/O thread exiting, read up to log 'ULFS01_LOGbv2.000001', position 70026728

So if could give me some advice on this. Master loads the data .... puts the data in the binary log..... and the slave can't read... replication breaks...
That would be for now..... Received on Thu Aug 30 05:53:19 2007