maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #06578
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