Ok, no answers yet, but more information:
master log:
010909 3:15:36 failed in send_file() : Failed reading file name
Should the same file used on the master for the "load inline" be already on
the slave? Or MySql takes care of moving it for us... I try to move myself
before the sql and didn't work... same error....
Also, ignore table doesn't work when table on the inline query. I tried that
and the slave tried to run the sql....
Configuration: Mandrake + Mysql 3.23.36
Please help, I would hate to leave replication just because this...
---------
Regards,
Rod~
> -----Original Message-----
> From: Rodrigo Zerlotti [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, September 08, 2001 7:58 PM
> To: Mysql@Lists. Mysql. Com
> Subject: URGENTE - Replication......
> Importance: High
>
>
> Can not find the problem and we are down!
>
> Here the question again.... (Any advice on replication of "LOAD
> DATA INFILE" is very appreciated.)
>
> ----------------
>
> I setup a mster-slave. My master does a lot of :
>
> LOAD DATA INFILE 'path-to-file'
> REPLACE INTO TABLE TABLE-NAME FIELDS
> TERMINATED BY '\t' LINES TERMINATED BY '\n';
>
> Notice i am not using "LOCAL" because the docs states:
>
> LOAD DATA INFILE will be handled properly as long as the file
> still resides on the master server at the time of update
> propagation. LOAD LOCAL DATA INFILE will be skipped.
>
> But on Slave I am getting:
>
> Slave: Error 'Table '%-.64s.%-.64s' doesn't exist' running load
> data infile
>
> Ideas???? Where should I look???
>
> ---------
> Regards,
>
> Rod~
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
