@ Alex
re: Seems I don’t have a _connections table at all!
That seems to be the issue… for some reason Duplicator did not create the table and insert the data.
Look in the database.sql for this line CREATE TABLE{db_prefx}_connections(. Does it exist?
If it does, then it was exported fine. For some reason, not imported
Best guess is the source db supports FULLTEXT and the MAMP installation does not. If the create table command exists, which I suspect it does, look for a line at the end of the command that begins with FULLTEXT KEYsearch If it does, go to the Connections : Settings admin page, click the Search tab and disable the FULLTEXT search option. Now create a Duplicator package and setup a new installation and import it. Is the table created now?
