On Mon, Dec 20, 2010 at 9:00 AM, Anand <anand....@gmail.com> wrote:
> 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 >
