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)"
Last updated on MARCH 08, 2017
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms