Bug #48827 Replication for Innodb
Submitted: 17 Nov 2009 4:59 Modified: 20 Nov 2009 11:09
Reporter: lokesh kumar Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Replication Severity:S1 (Critical)
Version:mysql-5.4.3-beta-win32.msi OS:Windows
Assigned to: CPU Architecture:Any
Tags: innodb, replication

[17 Nov 2009 4:59] lokesh kumar
Description:
Dear Sir/Mam,

             I am lokesh kumar from India working as developer. Now i am facing one issue in Mysql. I am using innodb engine for my database. Its in LAN. I want to replicate those data into Web server. I have tried somany ways. But i cannt replicate innodb engine. But i can do it in MYIASM tables. I am using mysql-5.4.3-beta-win32.msi version now. 

             Please let me know that how can i solve this problem.

Thanks in advance,
Lokesh kumar.R

How to repeat:
Its telling that it cannt do key constraints for Innodb engine.
[17 Nov 2009 5:32] Valeriy Kravchuk
Please, be more specific and send error log from slave and exact text of error message you get.
[20 Nov 2009 9:26] lokesh kumar
I got the following error from mysql,

Error

SQL query:

LOAD DATA FROM MASTER

MySQL said: Documentation
#1189 - Net error reading from master 

Please help me to solve
[20 Nov 2009 11:09] Sveta Smirnova
Thank you for the feedback.

> Its telling that it cannt do key constraints for Innodb engine.

Please fix constraints. More information is at http://dev.mysql.com/doc/refman/5.4/en/replication.html and http://dev.mysql.com/doc/refman/5.4/en/innodb-foreign-key-constraints.html