Hi Anand, Just try 'load data local infile',it maybe work.
Eric 2010/12/20 Anand <anand....@gmail.com>: > Hi guys, > > i am facing a serious issue with my replication , i tried so many things but > no luck. > > my replication is running with mysql 5.0.51a in master and 5.0.90 in slave. > > we run LOAD DATA INFILE in master to process some csv files and load it into > a table, it runs perfectly well in master but when it comes to slave it > stops with SQL SYNTAX error > > i tried running the LOAD DATA INFILE manually on the slave , but it says > different error as below > > mysql> load data infile '/tmp/SQL_LOAD-4-3-161.data' into table t; > ERROR 1085: The file '/tmp/SQL_LOAD-4-3-161.data' must be in the database > directory or be readable by all > > when i chcked the file persmission it is > > -rw-rw---- 1 mysql mysql 0 Dec 18 23:53 /tmp/SQL_LOAD-4-3-161 > > > > snippet from my error log > ==================== > > 101219 0:06:32 [Note] Slave SQL thread initialized, starting replication in > log '.000127' at position 923914670, relay log > '/var/lib/mysql/slave-relay.000002' position: 39311 > 101219 0:06:32 [Note] Slave I/O thread: connected to master > 'repli_u...@221.131.104.66:3306',replication started in log '.000127' at > position 946657303 > 101219 0:06:33 [ERROR] Slave SQL: Error 'You have an error in your SQL > syntax; check the manual that corresponds to your MySQL server version for > the right syntax to use near ''' at line 1' on query. Default database: > 'caratlane_diamonds'. Query: 'LOAD DATA INFILE '/tmp/SQL_LOAD-4-3-161.data' > IGNORE INTO TABLE osc_diamond_backup FIELDS TERMINATED BY ',' ENCLOSED BY > '"' ESCAPED BY '', Error_code: 1064 > 101219 0:06:33 [Warning] Slave: You have an error in your SQL syntax; check > the manual that corresponds to your MySQL server version for the right > syntax to use near ''' at line 1 Error_code: 1064 > 101219 0:06:33 [ERROR] Error running query, slave SQL thread aborted. Fix > the problem, and restart the slave SQL thread with "SLAVE START". We stopped > at log '.000127' position 926912155 > > > > please help me fixing this .. > > thanks in advance.. > > thanks > Anand > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
