MySQL Forums
Forum List  »  Replication

LOAD DATA INFILE not replicating in XP
Posted by: Patrick Leary
Date: July 08, 2005 08:32AM

I am running Windows XP as a Slave to my Master which is on a Linux box. Both
are running MySQL 5.0.7 and replication is set up properly and functions fine.

Except when my Windows Slave tries to replicate a LOAD DATA INFILE statement .
The error I get is:

Last_Error: Error 'File 'C:WINDOWSTEMPSQL_LOAD-2-1-11.data' not found (Errcode:
2)' on query. Default database: 'namebank'. Query: 'LOAD DATA INFILE
'C:\WINDOWS\TEMP\SQL_LOAD-2-1-11.data' INTO TABLE `contact` FIELDS TERMINATED BY
'\t' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r''

I have added these to lines to my configuration file:
slave-load-tmpdir="C:/WINDOWS/TEMP/"
tmpdir="C:/WINDOWS/TEMP/"

But, even though they are actually changing the variables, the MySQL Replication
Process is still building a bad SQL statement.

I realize that the proper SQL statement is LOAD DATA INFILE 'C:\\WINDOWS\\TEMP...' or 'C:/WINDOWS/TEMP...', but is there anyway to tell the replication process to do so?

Has anyone running MySQL 5.0.3 on Windows or later been able to replicate a LOAD DATA INFILE statement from a Master?

Any help is greatly appreciated.

Options: ReplyQuote


Subject
Views
Written By
Posted
LOAD DATA INFILE not replicating in XP
3082
July 08, 2005 08:32AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.