MySQL Performance: MySQL => replication problem

replication problem [message #1739]

Tue, 04 September 2007 23:23

nappin
Messages: 8
Registered: November 2006

Junior Member

I realize this isnt a performance question per say, but I find this is the best place for mysql help Wink

Anyways, I'm trying to do replication but I keep getting this error on my slave db:

070904 19:29:17 [ERROR] Slave: Query caused different errors on master and slave. Error on master: 'Query execution was interrupted' (1317), Error on slave: 'Can't get stat of '/tmp/SQL_LOAD-2-1-5.data' (Errcode: 2)' (13). Default database: 'xxxxxxxxxx'. Query: 'LOAD DATA INFILE '/tmp/SQL_LOAD-2-1-5.data' IGNORE INTO TABLE xxxxxx FIELDS ENCLOSED BY '\'' (xxx, xxx, xxx)', Error_code: 0
070904 19:29:17 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000016' position 319355725

Is there anyway to fix this?

From doing some searching on the web, it appears replication does not work if I load the data into the master via LOAD DATA INFILE? If so, that's really a bummer Sad

Is the only way to get this to work to load my data without using LOAD DATA INFILE?

Thanks in advance,
Ray

Report message to a moderator