This file basically spawns a MySQL process to import a database dump. The first part of the error is more important for our needs:
This part of the error is coming directly from the spawned MySQL process. The specific issue is that Mysql is trying to insert data that has a duplicate key, in this case, a question mark. That doesn’t make sense, and hints at maybe a data issue in the SQL file.
It sounds like you’ve already downloaded the autoload.sql file. When you examine the lines around the line mentioned in the above error, 1966, what do you see?
Obviously don’t share any sensitive info from the raw DB here, but some things I’d be looking for when looking at the sql dump:
- What table is this value being inserted into?
- What is the value/key being inserted? Does it look like a regular string, or is it some garbled binary characters?
- What DB versions are in use? On the remote, and on your Local sites. If they are different versions, that might cause issues.
I’d love to hear about what you find!