You are probably right, small mySQL differences in source/host versions were probably the culprit.
As I am not shifting my site between two live sites, I finally decided that downgrading my MAMP version to match the lower version of my webhost was too complicated, so I used another plugin. I reckon Duplicator is very powerful and gives you a lot of custom install options, but may be a bit above my pay grade – I am a translator by trade!
In any case, thx for you prompt pointers. Very helpful.
Thanks Cory, will check it.
Info above was carefully anonymized.
Thank for the pointers, esmi, will check these resources out.
Only did a search in the forum but most hits are “courses plugins”, or “how to use Wp for courses” rather than what i am looking for.
Take care