On Mon, 26 Mar 2001, Maros Klempa wrote:
> Hi,
>
> I have two servers with MySQL 3.23.24-beta. One as master and one as slave.
> Replication between this two servers work fine. Now I want store pictures
> to table. On master server I use command
> INSERT INTO PICTURES (ID, PICT) VALUES (1, LOAD_FILE( '/images/image.jpg')).
> It work o.k. MySQL save file image.jpg to table PICTURES. But when I look to table
> PICTURES on slave server in field ID is value 1 but field PICT is empty. Why?
> Work function LOAD_FILE with replication correctly?
I'll just guess here: at the slave side, the command is ran excactly the same way.
This means that the slave will try to do a LOAD_FILE('/imag...') looking for the image
at its local fs. Of course will fail because the image doesn't reside on its
filesystem.
I think something similar was mentioned some weeks ago with regard to a LOAD DATA
INFILE... at the master side, in which case again the input_file didn't resize on the
slave filesystem and so the call failed. Correct me if i'm wrong.
regards,
thalis
---------------------------------------------------------------------
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