Re: [Maria-discuss] Restore from mysqldump fails with "Error in foreign key constraint"

5 Jun 2023

      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/