← Back to team overview

maria-discuss team mailing list archive

Re: Restore from mysqldump fails with "Error in foreign key constraint"



On 6/5/23 6:07 AM, Hartmut Holzgraefe wrote:
On 03.06.23 18:06, Mark Edwards wrote:
child says:
`provider` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_*general*_ci NOT NULL,

parent says:
`provider` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_*unicode*_ci NOT NULL,

notice collate does not match?  mariadb is very particular on how the keys have to match up perfectly.

I missed the start of this thread, but this problem looks like


Yep, that's it. Thanks so much. I suspect by the next time I need this backup for my test server, it'll have been fixed upstream.

Thanks also to Mark Edwards for his awesome support.