My Oracle Support Banner

Foreign Key Constraint Import To 8.4 Failed With Error "MySQL Error 6125 (HY000)" (Doc ID 3023312.1)

Last updated on JULY 17, 2024

Applies to:

MySQL Server - Version 8.4 and later
Information in this document applies to any platform.

Symptoms

 When importing dump file from old versions to 8.4 failed with error "MySQL Error 6125 (HY000): Failed to add the foreign key constraint. Missing unique key for constraint 'xxxx' in the referenced table 'xxxxx'"

Changes

 Importing SQL dump file to 8.4 database

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.