Duplicate primary key on import sql backup
-
I’m trying to import a sql backup of wordpress website with wordfence installed.
It gives me an error (and blocks import) because of primary column of table wp_wfblockediplog (and other wordfence tables too) containing strange encoding chars:
ERROR 1062 (23000) at line 1680: Duplicate entry '\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\xEF\xBF\xBD\xEF\xBF\xBD' for key 'PRIMARY'If I check sql file i can find something like:
INSERT INTOwp_wfblockediplogVALUES (‘\0\0\0\0\0\0\0\0\0\0ÿÿly’,’GB’,2,18964,’brute’),(‘\0\0\0\0\0\0\0\0\0\0ÿÿÂ7′,’US’,1,18964,’brute’),(‘\0\0\0\0\0\0\0\0\0\0ÿÿ\”{},’,’US’,1,18968,’waf’),(‘\0\0\0\0\0\0\0\0\0\0ÿÿ#ÃC’,’BE’,2,18965,’waf’),(‘\0\0\0\0\0\0\0\0\0\0ÿÿ.¡’,’RU’,5,18964,’brute’),(‘\0\0\0\0\0\0\0\0\0\0ÿÿ.¡’,’RU’,1,18968,’brute’),(‘\0\0\0\0\0\0\0\0\0\0ÿÿ6úg»’,’JP’,1,18968,’waf’),(‘\0\0\0\0\0\0\0\0\0\0ÿÿBs’,’US’,1,18962,’waf’),(‘\0\0\0\0\0\0\0\0\0\0ÿÿCÍ2′,’US’,1,18962,’waf’),(‘\0\0\0\0\0\0\0\0\0\0ÿÿl£éj’,’US’,4,18965,’waf’),(‘\0\0\0\0\0\0\0\0\0\0ÿÿ¢ý’,’SG’,1,18963,’brute’),(‘\0\0\0\0\0\0\0\0\0\0ÿÿ°¥\” ‘,’FR’,3,18967,’brute’),(‘\0\0\0\0\0\0\0\0\0\0ÿÿ¯ג,’IR’,1,18962,’waf’),(‘*øÀt9\0\0\0\0\0\0\0′,’DE’,4,18965,’waf’),(‘* \’D\0\0\0\0\0\0\0′,’DE’,1,18968,’waf’) [..]`Anyone has similar problem?
THanks
The topic ‘Duplicate primary key on import sql backup’ is closed to new replies.