MySQL Forums
Forum List  »  Replication

Interesting replication problem
Posted by: development
Date: August 25, 2005 11:26PM

Dear all,

I m facing one interesting problem in replication of databases, we are using mysql for our forum base email system; we are storing all the attachments of mails as a binary data in table's blob column; the steps of this operation is first to upload the file from local machine to server using php functions and from there we are inserting into the table using 'Insert into.....( LOAD_FILE ('filepath') )'. Now the problem is my binary log just logs this query no any data, thus when any of the slave try to read from the log it gives either NULL or Error.

Thus the binary data is not replicated in my slave server.

Can anyone suggest me any new idea or solution ??

Thanks in advance

Options: ReplyQuote

Written By
Interesting replication problem
August 25, 2005 11:26PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.