Point-In-Time Recovery (PITR) Or Replication Fails After Changes Made With foreign_key_checks = 0: "ERROR 1452 (23000) at line ...: Cannot add or update a child row: a foreign key constraint fails (Unknown error code)"
(Doc ID 2163311.1)
Last updated on MARCH 24, 2019
Applies to:MySQL Cluster - Version 7.3 and later
Information in this document applies to any platform.
When trying to perform a point-in-time recovery (PITR), replaying the binary log fails with:
A typical case where disabling foreign key checks is required is when restoring data from a mysqldump backup.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document