← Back to team overview

maria-discuss team mailing list archive

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

 

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

https://jira.mariadb.org/browse/MDEV-31086

to me.

--
Hartmut Holzgraefe, Principal Support Engineer (EMEA)
MariaDB Corporation | http://www.mariadb.com/



Follow ups

References