MySQL Bugs: #55471: How can i recover Foreign Key Constraint Issue

Bug #55471	How can i recover Foreign Key Constraint Issue - REPLICATIOn
Submitted:	22 Jul 2010 7:40	Modified:	22 Jul 2010 7:42
Reporter:	Anil Alpati	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.1.45	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
How can i recover Foreign Key Constraint Issue while restoring Incremental Backup

By mistake I have skipped some of the bin-logs. So I'm facing foreign key constraint issue while restoring the same

Please help me out how can i fix the same. Any command line for recovery.

Since I'm running in PRODUCTION LIVE DATABASE

Awaiting from your solution/feedback on this ?

Kindly response at your earliest .

Thanks in advance.
Alpati

How to repeat:
100721 13:28:33 [ERROR] Slave SQL: Could not execute Write_rows event on table schema.table; Cannot add or update a child row: a foreign key constraint fails (`schema`.`table`, CONSTRAINT `table_ibfk_1` FOREIGN KEY (`columnname`) REFERENCES `account` (`columnname`) ON DELETE NO ACTION ON UPDATE NO ACTIO), Error_code: 1452; handler error HA_ERR_NO_REFERENCED_ROW; the event's master log FIRST, end_log_pos 10530730, Error_code: 1452

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.