Ok, got no emails, but I believe I found the problem , which I would
consider a bug.
My LOAD DATA INFILE query was running from a bash script, which was
executing the query thru a command line mysql call. The LOAD DATA was
loading the file into 2 tables on 2 different databases.
Something like:
LOAD DATA INFILE 'path-to-file'
REPLACE INTO TABLE database1.TABLE-NAME1 FIELDS
TERMINATED BY '\t' LINES TERMINATED BY '\n';
LOAD DATA INFILE 'path-to-file'
REPLACE INTO TABLE database2.TABLE-NAME2 FIELDS
TERMINATED BY '\t' LINES TERMINATED BY '\n';
Notice that both tables was qualified by the database, 1 and 2. Of course,
to run the command line, I had to logon, choosing one of the databases (they
have permissions to update each other).
The problem is that it would work on the master, but it was executing
(looking at log-bin) the query not qualified. The second statement would
look like:
LOAD DATA INFILE 'path-to-file'
REPLACE INTO TABLE TABLE-NAME2 FIELDS
TERMINATED BY '\t' LINES TERMINATED BY '\n';
and TABLE_NAME2 was not on database1, where I logged on.
I believe this is bug. The replication engine should keep the qualification
on the table name.....
---------
Regards,
Rod~
> -----Original Message-----
> From: Rodrigo Zerlotti [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, September 09, 2001 3:57 AM
> To: Mysql@Lists. Mysql. Com
> Subject: RE: URGENTE - Replication......
> Importance: High
>
>
> 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
>
---------------------------------------------------------------------
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
