XF 2.1 Error importing users


Well-known member
I'm trying to import my production database into a test environment.

Importing of users fails with:
Error restoring dbname.xf_user from file dbname.xf_user.sql.gz: Duplicate entry '?????' for key 'xf_user.username'

Problem is, I cannot find the entry ????? in the dump file when I edit it in a texteditor. Anyone has any idea?


Well-known member
Source server: MariaDB 10.4 with utf8mb4_general_ci collation
Destination server: Mysql 8.0 with utf8mb4_0900_ai_ci collation

Shouldn't be a problem I guess?

PS. Tried to dump with mysqldump and mydumper. Same results...
PS2. Total database is about 30GB in size with the duplicate user being the only issue. If it was encoding I would see more errors...