Hi Megan, thank you for looking into this! I can confirm that this happens every time I try to import, whether the export is from the current version of Local or an older version. However, this only occurs when I’m using a starter instance that I’ve been using through several versions of Local by Flywheel.
If I create a plain new site using Local Lightning, it exports and imports fine.
I’m guessing there’s something in the database version conversion that’s failing. I absolutely need to be able to import and export sites created outside of the latest version of Local Lightning.
Here are my logs. I emptied them, then exported my starter site (ravensegg) and attempted to import it and failed. Then I created a fresh site (exporttest) and imported it (importtest) successfully.
OS version: MacOS 10.14.6
Local version 5.0.6+976
local-lightning.log (31.1 KB)
error.log (265 Bytes)
Here’s the SQL file that the Local log says it’s choking on: local.wp_comments.zip (623 Bytes)
I took one further step by deleting the comments from the site before export to see what would happen. This time the import choked on the next table in the database with a similar error message:
I’ve changed the title of this thread to reflect that I think this problem is independent of whether I use multisite or not. It seems any import of any site that originally lived on my previous install of Local by Flywheel fails in a similar way.
Here’s some background I found on this, although since I’m not developing Local I can’t poke around in the source code to try anything: https://serverfault.com/questions/462682/mysql-error-1062-duplicate-entry-when-restoring-backup